Forum Discussion
Cascading Filters in Power BI
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
1 Reply
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.