How to define a filter selection value based on another filter value defined by a user in Looker Exp

For example, I have defined two dimensions in my view: City and Country. I want that, if there is a filter value selected in Looker Explorer related to the dimension "Country," the options to select in a filter related to the dimension "City" should be only the cities that correspond to the value selected in the filter "Country" before.
In summary, I want a value of a filter selected before to be used to restrict the options to select in the next filter.

How can I implement this behavior in LookerML?

Captura de Tela 2025-02-27 às 18.24.22.png

Captura de Tela 2025-02-27 às 18.26.05.png

0 1 74
1 REPLY 1

you can use link feature on the dashboard

Dashboard filters can be linked so that the filter value options for one filter are narrowed based on the filter value or values selected for a different filter on the same dashboard.

For example, you can link a dashboard filter for City to a separate filter for State. The filter value options for City will change based on the state or states selected in the State filter.

Once you select a filter value for State, a link icon appears with the City filter. If you hold the pointer over the link icon, a box appears that states that the value options for that filter have been narrowed by the State filter.

Top Labels in this Space