About controls

Let viewers apply filters and set parameter values.

Controls let viewers interact with the data displayed in a Data Studio report in the following ways:

  • Viewers can filter the data by specific dimension values.
  • Viewers set the time frame of the report.
  • Viewers can set parameter values that can then be used in calculated fields or passed back to the connector.
  • Viewers can change the underlying data set used by a data source.
To learn how to filter the data before viewers see it, use a filter property.

Add a control to a report

  1. Edit your report.
  2. In the toolbar, select Control icon. Add a control.
  3. Select the control type, then position on the page.
  4. On the right, use the options in the properties panel to configure the control.
    1. To filter the report by selected dimension values, use a dimension for the Control field.
    2. To set the value of a parameter, use that parameter as the Control field.

How controls work

Controls serve 2 main purposes:

  • Controls let viewers filter or change the data displayed in the report's components.
  • Controls provide the report editor a way to gather user input and use it in calculated fields and in connectors that support parameters, such as BigQuery and community connectors.

Controls as filters

When a control is based on a dimension (you add a dimension from the available fields list as the Control field), the control acts as a filter on the data.

For example, a list control based on the Country dimension let the viewer filter the data by country. An advanced filter based on a Product SKU dimension lets the viewer filter by all or partial part numbers.

More about filters

Controls filter all components on the page based on the same data source as the control itself, or that have matching field IDs. Controls can also filter components if the data sources are different, but are based on the same fixed schema connector, such as Google Ads and Google Analytics, because the internal field IDs are identical between data sources created by those connectors.

To limit a control to a subset of the components on the page, group them with the control.

Controls can filter other controls. For example, say you have one filter on the Country dimension, and a second filter on the Campaign dimension. Filtering on Country = France causes the Campaign filter to only show campaigns that ran in France. Similarly, filtering on campaign "ABC" restricts the Country filter to only those countries where that campaign ran.

Controls can only filter by a single dimension. To create a control that filters by more than one dimension, you have several options:

  • Create multiple filter controls, one for each dimension you want to filter by.
  • Concatenate the dimension data you want to filter by in a calculated field in the data source.
  • Concatenate the dimension data you want to filter by in the underlying data, if possible.

To filter by metric values, you can add a metric slider to individual charts.

Controls as input

When a control is based on a parameter (you add a parameter from the available fields list as the Control field), the control provides the viewers input to that parameter. Parameters are like variables that get their value from the viewer's interaction (say, by typing in a value directly, or picking a value from a predefined list).

You can use parameters to make calculated fields more dynamic. For example, you could create a Sales Target parameter and use it as the control field for a Input box to let viewers enter different sales goal numbers to visualize projected performance. You could then apply conditional formatting rules that highlight the results in eye-catching ways.

You can also pass parameters back to the underlying SQL query used to create a BigQuery data source, or to data sources created using community connectors.

Learn more about parameters.

Types of controls

The controls menus is divided into 2 sections:

"Add a control" menu.

The controls in the first section can be used to filter data, or to set parameter values. The controls in the second section perform specialized functions and can't be used to set parameter values.

Drop-down list and Fixed-size lists

These controls show the viewer a list of options from which they can select. The list can come from the values in a dimension, or from a list of acceptable values defined for a parameter.

List control DATA options

Most of the DATA options only apply to controls as filters. To configure parameter data options, edit the parameter in the data source.

Data Source

Provides the dimensions and parameters you can use in the control.

Date range dimension

This option appears if your data source has a valid date dimension. For Google Ads and Analytics data sources, this option is automatically set to the Date dimension.

The Date Range Dimension is used as the basis for limiting the date range of the chart. For example, this is the dimension used if you set a date range property for the chart, or if a viewer of the report uses a date range control to limit the time frame.

Dimension

Provides the list of values that appear in the control.

Control field

The dimension to filter by or the parameter whose value is set by this control.

Default selection

Specify default values, separated by commas. Be sure to enter the values exactly as they appear in your data.

Metric

This option displays a reference metric in the control. You can use this to sort the list, however, the viewer can't filter based on a metric value. To hide the metric, uncheck the Show values option.

Decimal precision

Specify the number of digits in the metric value to show.

Order

This option controls the sort order and number of values listed in the control. You can sort the values list in either ascending or descending order by the dimension values, or by the reference metric.

Show top #

This option limits the number of items displayed in the control. If the number of items available exceeds this limit, remaining items are grouped into "All others."

Default Date Range

This option limits the values displayed in the control to the range you specify.

Filter

Restrict the data displayed in the control by including or excluding the values you specify.

 

Google Analytics segment

This option appears for components based on a Universal Analytics data source.

A segment is a subset of your Analytics data. You can apply segments to your Data Studio charts to help ensure that your Data Studio and Google Analytics reports show the same data. Learn more about Analytics segments in Data Studio.

 

List control STYLE options

Drop-down

Displays the control in a drop-down box.

Fixed-size

Displays the control as a fixed-size box.

Single-select

Restricts the viewer to choosing only one option from the list. Note that parameter controls only support selecting single values.

Enable search box

Lets viewers search for values in the list.

Input box

Input boxes let the viewer enter a value. When used as a filter, you configure how the control matches the user's input against the dimension values. When used as input to a parameter, the input box can accept any value, values from a list, or a range of values.

Input box DATA options

Data Source

Provides the dimensions and parameters you can use in the control.

Dimension

Provides the list of values that appear in the control.

Control field

The dimension to filter by or the parameter whose value is set by this control.

Input box STYLE options

Drop-down

Displays the control in a drop-down box.

Fixed-size

Displays the control as a fixed-size box.

Input box auto width

When checked, the entry field's width automatically sizes to fit the available space. To set the entry field's width manually, uncheck this option and enter the desired width in characters.

Label position

Sets the appearance of the control's label.

Search type

Available for controls as filters. Determines the default search operator:

  • Equals (default). The value exactly matches the search term. (Case sensitive.)
  • Contains. The value contains the search term.
  • Starts With. The value begins with the search term.
  • Regexp. The value matches the regular expression
  • In. The value matches one or more of the search terms (enter search terms separated by commas).

Advanced filter

Advanced filters are similar to input boxes, but they can only be used as filters. Advanced filters can't set parameter values.

Advanced filter DATA options

Data Source

Provides the dimensions and parameters you can use in the control.

Dimension

Provides the list of values that appear in the control.

Control field

The dimension to filter by or the parameter whose value is set by this control.

Advanced filter STYLE options

Drop-down

Displays the control in a drop-down box.

Fixed-size

Displays the control as a fixed-size box.

Input box auto width

When checked, the entry field's width automatically sizes to fit the available space. To set the entry field's width manually, uncheck this option and enter the desired width in characters.

Label position

Sets the appearance of the control's label.

Search type

Determines the default search operator:

  • Equals (default). The value exactly matches the search term. (Case sensitive.)
  • Contains. The value contains the search term.
  • Starts With. The value begins with the search term.
  • Regexp. The value matches the regular expression
  • In. The value matches one or more of the search terms (enter search terms separated by commas).

You can filter by numeric dimensions values using the following operators:

  • Between. The value is between the starting and ending numbers.
  • >= The value is greater than or equal to the number.
  • > The value is greater than the number.
  • <= The value is less than or equal to the number.
  • < The value is less than the number.
  • In. The value matches one or more of the search terms (enter search terms separated by commas)

Slider

Slider controls let viewers filter by a range of values in a numeric dimension, or select a single value from a numeric parameter.

Slider DATA options

Most of the DATA options only apply to controls as filters. To configure parameter data options, edit the parameter in the data source.

Data Source

Provides the dimensions and parameters you can use in the control.

Date range dimension

This option appears if your data source has a valid date dimension. For Google Ads and Analytics data sources, this option is automatically set to the Date dimension.

The Date Range Dimension is used as the basis for limiting the date range of the chart. For example, this is the dimension used if you set a date range property for the chart, or if a viewer of the report uses a date range control to limit the time frame.

Dimension

Provides the list of values that appear in the control.

Control field

The dimension to filter by or the parameter whose value is set by this control.

Default selection

Specify default values, separated by commas. Be sure to enter the values exactly as they appear in your data.

Order

Show top #

Limits the number of items displayed in the control to the top N values.

Default Date Range

This option limits the values displayed in the control to the range you specify.

Filter

Restrict the data displayed in the control by including or excluding the values you specify.

 

Google Analytics segment

This option appears for components based on a Universal Analytics data source.

A segment is a subset of your Analytics data. You can apply segments to your Data Studio charts to help ensure that your Data Studio and Google Analytics reports show the same data. Learn more about Analytics segments in Data Studio.

 

Slider STYLE options

Drop-down

Displays the control in a drop-down box.

Fixed-size

Displays the control as a fixed-size box.

Label position

Sets the appearance of the control's label.

Slider mode

Available for controls as filters.

  • Range. The viewer can adjust the minimum and maximum values.
  • Single value. The viewer can use the slider to select a single value.
  • Locked min. The viewer can adjust the maximum value in the range.
  • Locked max. The viewer can adjust the minimum value in the range.

Min value / Max value

Available for controls as filters. Sets the minimum and maximum values in the slider.

Snapping

Step size

Sets the size of each movement of the slider thumb. For example, to have each move of the slider thumb increase or decrease by 10, set Step size to 10.

Show tick marks / Tick interval

Shows marks on the slider bar at the specified interval.

Text

Shows a text label for the current minimum and maximum slider values.

Checkbox

Checkbox controls let viewers filter by a Boolean dimension or set the value of a Boolean parameter.

Checkbox DATA options

Data Source

Provides the dimensions and parameters you can use in the control.

Dimension

Provides the list of values that appear in the control.

Control field

The dimension to filter by or the parameter whose value is set by this control.

Checkbox STYLE options

Drop-down

Displays the control in a drop-down box.

Fixed-size

Displays the control as a fixed-size box.

Label position

Sets the appearance of the control's label.

Date range control

The date range control is a customizable calendar widget that enables your viewers to change the time frame of a report.

Learn more.

Data control

The data control lets viewers change the underlying data set to which a data source connects. This makes it easy for you to share reports with viewers who want to use that report with their own data. Using a data control can eliminate the need to create a separate report for each customer or consumer.

The data control only supports selected fixed-schema data sources.

Learn more.

Change the control type

You can switch an existing control on the report from one type to another:

  1. Edit your report.
  2. Select the control.
  3. On the right, at the top of the properties panel, open the control selector .
  4. Select the new control type.

You may need to edit the control's settings to use the new type.

Make a control appear on every page

You can make a control appear in the same location on every page of your report. Filters or parameters set on one page will carry over to all the pages in the report.

  1. Edit your report.
  2. Select the control.
  3. Select the Arrange > Make Report-level menu.
Can't find the control on other pages? It may be underneath other components on the page. Learn more about report-level component position.

About parameters

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue