Skip to main content
Microsoft Idea

Power BI

New

Clear slicer selections based on another slicer

Vote (13) Share
Alexander Kassouf's profile image

Alexander Kassouf on 23 Mar 2022 15:34:53

Have the ability to clear a slicer based on changing another slicer.


Ex:


slicer 1 has departments: Food, Clothing, Pharmacy


slicer 2 has categories under the departments:

Produce, Frozen, Shirts, Pants, Medicine, Toothpaste


If you have Food and Frozen selected, and go back to slicer 1 to choose “Pharmacy”, then slicer 2 should automatically clear its selections, because the visuals will show no data if Pharmacy and Frozen is selected.