Forum Discussion
Connectivity between Filters
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?
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?
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
2 Replies
- saranyasaranRegular Visitor
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?
- MFelixSuper User
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