Multi Level Slicer

Question

I have created multiple slicers dependent on each other. The problem I am facing is that whenever I am changing the selection of the first slicer then its depending slicer is also changing (which is correct) but its keep the last selected value until I select the new value.&nbsp;

nandukrishnavs · Answer

Anonymous&nbsp;&nbsp;Use&nbsp;a hierarchy slicer. You can use the default slicer as a&nbsp;hierarchy slicer or get the custom visual from the store.https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/Also, you could disable the interaction between the multiple slicers, so that one selection will not filter out other slicers.&nbsp;https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactionsDid I answer your question? Mark my post as a solution!Appreciate with a kudos 🙂

amitchandak · Answer

Anonymous , Try Hierarchical Slicer from Feb 2020 release 
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/

anonymous · Answer

Thanks for providing the solution. Now I have two levels slicer with region and country as levels. However when I select a country under the region level it shows Multiple Selections as selection instead of the country name. I have attached the screenshot also.

nandukrishnavs · Answer

Anonymous&nbsp;Since you are using the slicer as dropdown, it is expected. Please change it as a list. Or maybe you can write a new DAX measure to show selected items.&nbsp;https://community.powerbi.com/t5/Desktop/display-multiple-elements-with-SELECTEDVALUE/td-p/650754&nbsp;

Forum Discussion

Multi Level Slicer

4 Replies

Related content

Multi level drill-trough

Mandatory multi select slicer

Multi level hierarchy in Gantt chart by microsoft corporation

Multi-level JSON column

Multi Level Column Headers