How to apply a page filter to a Looker Studio report filter

Looker Q&A Looker
1

Hello,

I am looking to create a dependency between two filter controls in Looker Studio.

Currently, I have two controls:

  1. Control A (Page-level control) on the Category dimension.

  2. Control B (Report-level control) on another dimension (e.g., Subcategory or Product).

My goal is for the user’s selection in Control A (Page Filter) to dynamically limit the list of options displayed in Control B (Report Filter) to only the relevant options.

For example:

  • If I select “Clothing” in Control A (Category),

  • I only want to see “Shirts,” “Pants,” “Dresses” (and not all report options, such as “Televisions” or “Books”) in the dropdown list of Control B.

Currently, both controls independently affect the charts, but the options within Control B are not filtered by Control A.

Is it possible to implement this type of cascading (parent-child) filtering in Looker Studio?

Thanks

1 Like
2

Hi @SteveF , I don’t think that’s possible. If you switch both filters to page level or both to report level, they will filter each other. But at different levels, it’s more difficult. Control B at the report level can filter Control A at the page level. However, Control A at the page level cannot filter Control B at the report level. You also cannot group them if they are created at different levels. One option would be to switch the report-wide filter B to the page level, but then you would have to repeat the filter setting manually on each slide.

1 Like
3

Hello @Isabell_Börner , thank you for your feedback.