Need Help with Slicer Behavior in Power BI: How to Enable/Disable Regions Based on 'ALL' Selection

[Shivigupta]

Hello everyone,

I have a requirement for a slicer that displays six region names. Five of these regions are named, and the sixth one is named "ALL" region. Here's the requirement: If a user selects "ALL" region, the other five regions should be deselected and disabled. However, if a user selects any of the five named regions, "ALL" region should be deselected and disabled.

I need assistance with implementing this.

 

[Anonymous · Accepted solution]

Hi @Shivigupta 

You can consider to create a bookmark called "All",  add a bookmark and hide the slicer visual.

Then create a bookmark called "Region", display the slicer visual.

Then add a bookmark button

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You seem to be trying to reinvent existing functionality.  On your slicer, enable the "Select All"  option.