CODEWITHSUNDEEP
looker-studio
ERJAN
ERJAN

Reputation: 24500

How to add a Drop-down Control that Filters Data Dynamically?

In Excel we have 3 dropdown menus to select by city, branch - the charts on the right are redrawn according to selected city:

When migrating to Google Data Studio, it seems it has limited functionality to do the same thing:

Upvotes: 1

Views: 7038

Answers (1)

Nimantha
Nimantha

Reputation: 6461

Individual Drop-down lists can be used to view subsets of the data (using one for city another for branch, etc). Selecting items in one Control will automatically filter values in the other Control(s).

Editable Google Data Studio Report (Embedded Google Sheets Data Source) and a GIF to elaborate:

Upvotes: 3

Related Questions