Connectivity between Filters

[saranyasaran]

i am creating a filter which will be linked to another filter. Eg : i created 2 filters say Country and Region. so if i click on Country filter, the region filter should change accordingly based on the country filter selection. How is this possible in Power BI desktop? Any idea?

[MFelix · Accepted solution]

Hi  @saranyasaran,

I suppose you have a single table with country / region when you add the filters/slicers to your report they are interacting with each other if you want them to act individually you need to change the option in the Edit Interactions:

I have place this in slicers but the same thing happens in the filters on the visual/page/report level, however if you don't have a connection between the two columns first of all you need to add a relationship or make a table with a link between the two columns you want to use as a connect filters and then use the solution above.

Regards,

MFelix

[MFelix · Accepted solution]

Hi  @saranyasaran,

I suppose you have a single table with country / region when you add the filters/slicers to your report they are interacting with each other if you want them to act individually you need to change the option in the Edit Interactions:

I have place this in slicers but the same thing happens in the filters on the visual/page/report level, however if you don't have a connection between the two columns first of all you need to add a relationship or make a table with a link between the two columns you want to use as a connect filters and then use the solution above.

Regards,

MFelix

[saranyasaran · Accepted solution]

i am creating a filter which will be linked to another filter.

Eg : i created 2 filters say Country and Region. so if i click on Country filter, the region filter should change accordingly based on the country filter selection. How is this possible in Power BI desktop? Any idea?