Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsi 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsi 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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |