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.
Hi All
How do I achieve cascading filters in Power BI?
E.g One filter has countries like India, US etc and the other filter has cities.
If I choose country India in the first filter, it only show cities in India in the second filter
Pls let me know how this can be achieved?
Rgds
Amit
This happens automatically for me when I am creating slicers. You may want to check that your slicers are set to filter one another. Select a slicer and click 'Edit Interactions' under the format tab on the toolbar at the top. This will allow you to see which visuals the selected slicer is filtering, shown at the top corner of each visual.
If the slicer is set to filter the other slicers, then it may be that your country and city fields are not in the same table or not related in such a way that allows them to filter one another.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |