If you’re looking for a simple way to make your reports more interactive, dropdown lists in Data Studio are a great place to start. They allow viewers to select one or more values and immediately filter the charts on the page, without editing the report or changing the underlying data.
The Dropdown List and Fixed List are two very similar control types. Both give the end user a list of values they can use to filter the report, but they display those options differently. The Dropdown List stays collapsed until the user opens it, while the Fixed List keeps the available values visible on the page.
Let’s explore how I use dropdown lists in Data Studio, how the two controls differ, and when each option works best.
Visit my post on how to add controls to your report in Data Studio if you need a refresher before getting started.
For the examples in this post, I’ve used the Superstore Products dataset. You can also visit my post on how to add data sources in Data Studio to learn more about the dataset and how to access it.
How fixed and dropdown lists in Data Studio work
Controls allow viewers to interact with a report and decide which data they want to see. When someone selects a value from a list, the charts connected to that control are filtered automatically.
For example, you could allow viewers to filter a sales report by product category, country, campaign, device or customer segment. This makes the report more flexible because the same set of charts can answer several different questions.
Both the Dropdown List and Fixed List can allow users to select one or multiple values. The main difference is how much space they take up and whether the list is initially expanded.
1. The Dropdown List control
What is a Dropdown List?
A Dropdown List allows users to select one or more values to filter the charts on the page they’re viewing. The list remains collapsed until the user clicks on it, which means it takes up very little room in the report.
At the top of the expanded list, there is also a search box for finding specific values. This is particularly useful when the control contains a long list of products, cities, campaigns or other options.
When should you use it?
I use this control when I want viewers to choose one or multiple categories without using too much space on the page. Of the different list controls in Data Studio, this is usually the option I choose when the dimension contains many values.
It works especially well in reports where most of the available space needs to be reserved for charts, scorecards and explanatory text.
Example: filtering products by subcategory
Let’s create a table containing Product Name as the dimension, together with Quantity and Gross Revenue as the metrics.

To create the table, select Product Name as the dimension and add Quantity and Gross Revenue as the metrics.
In the Style section, I changed the header text colour to blue. Under Table Colours, I set the Header Background Colour to transparent and the Odd Row Colour to light grey.
Now imagine that you want viewers to filter this table by the different product subcategories.
Here’s how I set it up:
- Add a Dropdown List control to the report.
- Select Subcategory as the control field.
- Add either Quantity or Gross Revenue as the metric.
- Enable Show values if you want the metric to appear next to each option.
Because we’re analysing quantity and gross revenue by product, either metric would work. I prefer adding a metric because it gives the viewer more context, but displaying the values is optional.

The first image below shows the Dropdown List before it has been expanded. As you can see, it takes up very little space on the page.

The second image shows the list after the user clicks to expand it. They can now search for a subcategory and select one or more values to filter the product table.

2. The Fixed List control
What is a Fixed List?
The Fixed List works in the same way as the Dropdown List, but the options are already expanded and visible on the report page. It also includes a search field at the top.
The user doesn’t need to click to open the control before selecting a value. This makes the options easier to discover, although the control requires more space than a Dropdown List.
When should you use it?
Use the Fixed List when you want to display the available options without requiring the viewer to expand the control. Essentially, it saves them a click.
It works particularly well when the control field only contains a small number of values. If the dimension contains many options, the viewer will still need to scroll through the list, just as they would with an expanded Dropdown List.
Example: filtering by product category
The Fixed List in the following example uses Category as the control field. Because this dimension only contains three values, all the options can be displayed on the screen without scrolling.
I’ve used Gross Revenue again as the metric. As well as providing additional context, the metric can be used to sort the categories according to the revenue they generated.

The Fixed List above is configured as follows:

Dropdown List vs Fixed List in Data Studio
Both controls filter data in the same general way, so the best option usually depends on the number of values and the amount of space available in your report.
- Use a Dropdown List when the dimension contains many values or when you want to save space.
- Use a Fixed List when there are only a few values and you want the choices to remain visible.
- Add a metric when the values will provide useful context or help you sort the available options.
- Use the search field when viewers may need to find a specific value within a longer list.
I personally use the Dropdown List more often because it leaves more space on the page for charts. However, the Fixed List can provide a better experience when there are only a few clear options to choose from.
Final thoughts on fixed and dropdown lists in Data Studio
Fixed and dropdown lists in Data Studio are a simple but effective way to give viewers more control over the data they see. Both the Dropdown List and Fixed List allow users to filter a report without changing its structure or creating separate pages for every category.
The Dropdown List is usually the better choice when you want to save space or have many values, while the Fixed List works well when the available options are limited and should remain visible.
Which of the two controls do you prefer? I personally use the Dropdown List more often because it leaves more room for charts, but both can be very useful depending on the design of your report.
As always, your comments and questions are more than welcome!
FAQs – Fixed and dropdown lists in Data Studio
-
u003cstrongu003eWhat are dropdown lists in Data Studio?u003c/strongu003e
Dropdown lists in Data Studio are report controls that allow viewers to select one or more dimension values and use them to filter the charts on a report page.
-
u003cstrongu003eHow do I add a Dropdown List in Data Studio?u003c/strongu003e
Add a control to the report, select Dropdown List and place it on the canvas. You can then choose the dimension you want viewers to use as the control field.
-
u003cstrongu003eWhat is the difference between a Dropdown List and a Fixed List?u003c/strongu003e
A Dropdown List remains collapsed until the user opens it, while a Fixed List displays the available values directly on the report page. Both can be used to filter charts.
-
u003cstrongu003eCan users select multiple values from a Dropdown List?u003c/strongu003e
Yes. A Dropdown List can allow viewers to select multiple values, enabling them to filter the report using more than one category at a time.
-
u003cstrongu003eShould I add a metric to a list control?u003c/strongu003e
Adding a metric is optional. It can provide useful context and help sort the available values, but you can disable Show values if you prefer a simpler list.

Comments