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 is a user control that lets viewers narrow the data displayed in a report based on the values in a selected dimension. For example, a Browser filter control lets viewers filter the report according to the selected web browsers. This gives your audience the ability to refine the data they see according to their individual needs and interests.

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

Adding a Filter control is like adding any other chart or control:

  1. Select the Filter control tool Dimension Filter icon
  2. Draw the filter control on the page
  3. Configure the control in the Property panel
How about a bit more help?
  1. Edit the report.
  2. Select the Filter control tool from the toolbar Dimension Filter icon
  3. Draw the filter control in a nice spot on the page
  4. Set up the filter control options:
    1. Select the Dimension. This is the dimension by which your audience can filter the report.
    2. Select the reference Metric. This is the metric that will sort the dimension values.
    3. To hide the metric column, uncheck Show Values. The dimension list will still be sorted by that metric, but viewers won't see what it's sorted by. (This is another way to save space on the report.)
    4. The Show Top # drop-down determines the number of dimension values to display. The list will scroll if you have more items than that.
    5. Use the STYLE tab options to make the filter control beautiful.

How filter controls work

Filter controls display the values for the selected dimension as a list of checkboxes. Viewers of the report select the items by which they want to filter the report. Charts in the report will then only display data according to that filter.

There are 2 factors that determine whether a chart will be affected by a filter control: data source and scope.

Filter controls and data sources

Filter controls only apply to charts that use the same data source as the control. In other words, a filter on a dimension A from data source 1 will only apply to charts that use data source 1. Any charts based on data source 2 will not be affected by that filter.

Filter control scope

A filter controls' scope determines which charts it applies to. By default, filter controls apply to all the charts on the page on which it appears.

You can limit the effect of a filter to a subset of charts on the page by making the filter group scope. To do this, multi-select the filter and one or more charts. Then use the Align > Group menu (or right-click and and select Group). Now, the filter will only apply to the charts in this group.

Filter control example

Here's an example report of an online academy's performance that includes charts for completion rates and study time. The report also includes a filter control for 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 will also be filtered by your selection (assuming those charts are based on the same data source). For example, a Pie chart showing New vs. Returning Users will only show data for the selected courses.

Reference metric

Dimension filter reference metricFilter controls include a reference metric, which is used to sort the dimension values so that the most relevant values appear in the top of the list. For example, the Course filter control above includes the Course completions metric to order the list by the highest number of graduates, from highest to lowest.

You can hide the reference metric from viewers 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.

Save space with expandable filters

Check the Expandable checkbox to put the filter control into a drop-down menu. This can save space on your report.

A filter control is a user control that lets viewers narrow the data displayed in a report. For example, a Browser filter control lets viewers filter the report according to the selected web browsers. This gives your audience the ability to refine the data they see according to their individual needs and interests.

Make a filter control appear on every page

By default, every component you place on a report is a page-level object: it only appears on the original page on which you place it. You can make a filter control appear on every page of your multi-page report by making it report-level. To do this:

  1. Edit the report.
  2. Select the filter control (or other component).
  3. Select the Align > Make Report-level menu.

Your filter control will now appear in the same location on every page of your report.

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.