Skip to main content

Power BI

New

Toggle to change slicer behavior from OR to AND

Vote (2) Share
Winston Carter's profile image

Winston Carter on 13 Jun 2022 22:31:02

Right now slicer behavior includes all the selected options in the filtered visuals, so that if you have for example Group A and Group B and select both then you get items that are members of either group or both groups. I suggest that it be possible to make a slicer behave such that if you select Group A and Group B in the slicer that you only get items that are members of both Group A and Group B, with items that are members of only one of the two groups being excluded.

Comments (1)
Winston Carter's profile image Profile Picture

Michelle Congrove on 19 Jun 2023 13:10:23

RE: Toggle to change slicer behavior from OR to AND

further information for Microsoft when looking into this https://radacad.com/slicer-with-and-condition-in-power-bi - currently users have to build DAX formulas to change this behavior. Adding a toggle option would be FANTASTIC!