Skip to main content

Power BI

Needs Votes

Change behavior between multiple slicers ("OR" vs. "AND")

Vote (6) Share
Kyle's profile image

Kyle on 18 Feb 2017 00:35:47

Unless I missed something, there is no current way to change the interaction BETWEEN multiple slicers that refer to two DIFFERENT columns.
Example:
One slicer for eye color, and a different slicer for hair color (two different columns in the data).
If I choose Eye=blue and Hair=brown, the result will be all people in the dataset with blue eyes AND brown hair.
I need to selectively change this behavior so the result would be all people with blue eyes OR brown hair.

I can do this rather clumsily by creating a cartesian product columns and values but when I'm working with 6-8 columns that have 3-4 possible values each, the result is just ugly (not to mention difficult to navigate for the user).

If this idea already exists, please refer me to that posting as I have not been able to find it yet.