Add a filter control to a report
A filter control helps viewers focus on the data that interests them. Filter controls are "dimension filters," because they let users select one or more values from dimension by which to filter the report. For example, a Browser filter control lets viewers filter the report based on selected web browsers.
This article is about adding interactive filter controls to your report. For filter properties, which report viewers can't change or interact with, please see this article.
Filter controls give Data Studio editors a way to make their reports interactive. Report viewers can use these controls to refine the data displayed in the report.
Add a filter control to a report
- Edit your report
- In the toolbar, select Filter control
- Draw the filter control on the page
- On the right, use the Filter Control Properties to configure the filter.
Show me the filter control DATA properties
Filter control DATA tab properties
Switch between chart types. Note: some chart types may not work with the current selection of dimensions and metrics.
A data source provides the connection between the component and the underlying data set. Components in Data Studio currently can connect to a single data source.
Provides the values for the filter control list.
Displays a reference metric in the filter control.
|Show values||Shows or hides the metric.|
Controls the sort order and number of values listed in the control.
|Metric / Dimension||Sort the list by metric value or dimension value.|
|Ascending / Descending||Set the sort direction.|
|Show Top #||Limit the number of items to display in the control. If the number of items available exceeds this number, remaining items are grouped into "All others."|
Default Date Range
The default date range property lets you set a timeframe for an individual chart. Learn more about working with dates and time.
|Auto||Use the default date range determined by the chart's data source.|
|Custom||Lets you use the calendar widget to select a custom date range for the chart.|
|Date compare type||Displays comparison data for the selected time period.|
The filter property restricts the data displayed in the component by including or excluding the values you specify. Learn more about the filter property.
|Filter name||Click an existing filter to edit it. Mouse over the filter name and click X to delete it.|
|+Add a filter||Creates a new filter for the chart.|
Show me the filter control STYLE properties
Filter control STYLE tab properties
|Expandable||Displays the filter control as a drop-down menu. This can save space on your report.|
|Single select||Allows the viewer to select only one value at a time.|
|Enable Search Box||Displays a search box in the filter control to help users find values quickly.|
|Compact Numbers||Rounds numbers and displays the unit indicator. E.g., 553,939 becomes 553.9K.|
|Decimal Precision||Sets the number of digits after the decimal point.|
Sets the color of the list item text.
Sets the background color, font, and font color of the filter control header.
Sets the color of the checkboxes and dividers.
Sets the font family of the list item text.
Background and Border
These options control the appearance of the chart background container.
|Background||Sets the chart background color.|
|Border Radius||Adds rounded borders to the chart background. When the radius is 0, the background shape has 90° corners. Border radius of 100° produces a circular shape.|
|Opacity||Sets the chart's opacity. 100% opacity completely hides objects behind the chart. 0% opacity makes the chart invisible.|
|Border Color||Sets the chart border color.|
|Border Weight||Sets the chart border line thickness.|
|Border Style||Sets the chart border line style.|
|Add border shadow||Shows or hides the border shadow.|
Sets the padding of the list item text.
How filter controls work
Filter controls display the values for the selected dimension as a list. Viewers can select one or more list items by which to filter the report. Charts and controls in the report that are subject to the filter then only display data for the selected filter items.
For example, if you have a filter control based on the Browser dimension, and the viewer selects Chrome and Internet Explorer from the list, a time series chart on that page showing Sessions would only show data for sessions where the visitor was using one of those 2 browsers.
There are 2 factors that determine whether a chart will be affected by a filter control: field ID and scope.
Filter controls and field ID
Filter controls only apply to fields that have the same internal field ID as the dimension used in the filter control. For example, a filter control based on the Google Analytics Browser dimension will apply to all charts on the page that also have that dimension in their data source, because all Google Analytics data sources have the same default field IDs. But a field coming from another data source, say Google Sheets, will not be affected by the filter, even if it has a user-defined name of "Browser." This is because the field names you provide and the internal field IDs generated by Data Studio don't match.
Since you can't edit the internal IDs for the default fields in a data source, filter controls are only guaranteed to work when they are based on the same data source as the charts on that page.
Filter control scope
By default, a filter control applies to all the charts on the page (subject to the field ID matching rules described above).
You can restrict a filter to a subset of charts by grouping the filter with those charts. To do this, multi-select the filter and one or more charts. Then use the Arrange > Group menu (or right-click and and select Group). Now, the filter will only apply to the charts in this group.
Make a filter control appear on every page
By default, report components are page-level objects: they only appear on the page on which it was placed. To have a filter control (or any other component) appear on every page of a report, make it a report-level component. To do this:
- Edit the report.
- Select the filter control (or other component).
- Select the Arrange > Make Report-level menu.
Your filter control now appears in the same location on every page of your report.
Filter control example
This report shows course completion rates and study time for an online academy. The report includes a filter control based on the Course dimension. When you deselect Course B, both the course completions and study time charts update to show the data with Course B removed:
Other charts in the report that are based on the same data source as the filter are also affected by the filter. For example, a Pie chart showing Sessions for New vs. Returning Users would only show data for courses A, C, and D.
Filter controls can include a reference metric, which provides more context and can be used to sort the filter values list. For example, the Course filter control above includes the Course completions metric, in descending order by the number of graduates.
Filter by multiple dimensions or data sources
A filter control can only include a single dimension. If you want to let your viewers filter by more than one dimension or from dimensions from different data sources, you'll need to create separate filter controls.