There are many ways to make your Data Studio reports more interactive and dynamic. Using optional metrics, you can allow report viewers to change which metrics are shown in a chart. But have you ever wished you could do the same with dimensions?
While there is no native feature in Data Studio to enable “optional dimensions” in a chart, you can use parameters and calculated fields to achieve a similar result.
In this post, we will walk you through how to create a parameter control that allows viewers to change the dimension for any given chart on the fly.
1. Create a parameter
- Add a new parameter to your data source.
- Enter a parameter name and select “Text” as the data type.
- Configure the permitted values as a “List of values.” Add a value for each optional dimension that you wish to include.
- Select your desired default value.
2. Convert the parameter into a dimension
Add a new field that returns your optional dimension parameter:
3. Create a calculated field to return the list of dimensions
Create a calculated field that uses a CASE statement to return the respective dimension for each value of the parameter:
4. Create a chart with the calculated field
Add the calculated field from the previous step as a dimension into your chart:
5. Create a drop-down list control
Add a drop-down list control and select your parameter as the control field. This will allow report viewers to select which dimension displays in your chart.
Check out our example report in Data Studio, where you can use the drop down control to choose from the list of optional dimensions!