Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

Multi Level Slicer

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. 

4 REPLIES 4
amitchandak
Super User
Super User

nandukrishnavs
Super User
Super User

@Anonymous 

 

Use a hierarchy slicer. You can use the default slicer as a hierarchy slicer or get the custom visual from the store.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/

012220_2004_PowerBIDesk4

Also, you could disable the interaction between the multiple slicers, so that one selection will not filter out other slicers. 

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂


Regards,
Nandu Krishna

Anonymous
Not applicable

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.Slicer.PNG

@Anonymous 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. 

https://community.powerbi.com/t5/Desktop/display-multiple-elements-with-SELECTEDVALUE/td-p/650754

 


Regards,
Nandu Krishna

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.