In this post, I want to show you how to use the slider control in Google Data Studio to filter metric values. Now, this sounds like one of those tiny time-saver features, but the slider control is actually critical for complex dashboards. For example, in the past, you could add a metric as a filter, but then you would have to click on each distinct value to filter for it. This was not exactly the greatest user experience, especially if you have sales data. As a result, Google has introduced the “metric sliders”, which is a dynamic filtering option embedded in each chart. Let’s see how this thing works!
Also, if you want to follow the steps closely, I am using a public dataset called “[Sample] Google Analytics Data”. The dataset is available in all Data Studio accounts.
Time Needed : 3 minutes
For dashboard/report viewers, here is how to use a metric slider to filter a chart by a specific metric value.
You can use an existing report if you want to follow with your own data.
2.1 Once you enable the “Metric sliders”, you would notice that the “Optional metrics” would disappear; you can only have one at a time.
2.2 Also, in order to interact with the slider, you would have to switch to “View ” mode.
3.1 You can drag the ends of the slider to adjust the range of the values you want to filter for.
3.2 If you want to set the upper and lower bounds to specific values, you can click on each number and type the values right away.
You can always add addition metrics to the chart and the slider will auto-update. It is also important to know that if you filter by one metric, this would not affect the other metrics in the chart.
I hope this was a helpful trick to filter a metric in Google Data Studio! If you have any questions, feel free to DM me on LinkedIn or subscribe to my newsletter.
If you want to learn more about building complex dashboards, take a look at my full course on Udemy. The course has a dedicated section on advanced design and ways to make your dashboards more intuitive.
I've used Zapier for years to automate small tasks and create the lead generation system…
When I started creating custom GPTs for various tasks, one of the areas that I…
Over the past few months, I've had the opportunity to dive into Canva Magic Studio,…
In my nano tips series on ChatGPT so far, I've covered Data Storytelling and Visualization,…
It has been a while since my last post, but I finally managed to wrap-up…
Although cliché, the phrase "a picture is worth a thousand words" has never been more…
View Comments
It is good to see so many options which were hiding in settings. Thanks for explaining them clearly.
Great to see that this was helpful Nischal! :)