Search
Clear search
Close search
Google apps
Main menu

Add a filter control to a report

Give your viewers control over the data they see.

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.

In this article:

Video tutorial

Use filter controls

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

  1. Edit your report
  2. In the toolbar, select Filter control Dimension Filter icon
  3. Draw the filter control on the page
  4. On the right, use the Filter Control Properties to configure the filter.

Show me the filter control DATA properties

Filter control DATA tab properties

Section Property Notes
Chart Type
Switch between chart types. Note: some chart types may not work with the current selection of dimensions and metrics.
Data Source

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.

Dimension

Provides the values for the filter control list.

Metric

Displays a reference metric in the filter control.

  Show values Shows or hides the metric.
Order
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.
Filter

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

Section Property Notes
Filter Control
  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.
Text

Sets the color of the list item text.

Header
Sets the background color, font, and font color of the filter control header.
Checkbox
Sets the color of the checkboxes and dividers.
Label
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.
Padding
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:

  1. Edit the report.
  2. Select the filter control (or other component).
  3. 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:

Dimension filter example

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.

Reference metric

Dimension filter reference metricFilter 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.

You can hide the reference metric using the Show values option.

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.

Use filter controls to refine your view

Was this article helpful?
How can we improve it?
What's new in Data Studio

Learn about new features and recent changes.