Creating a Single Slicer for Group Selection in Power BI

[gautampruthi]

Hi I have 3 column as Group1,Group2,Group3 which contain yes/no

I want to Create a single slicer which will let user select which group they want to see.

Slicer
Options as Group1,Group2,Group3

so i user selects group1 then user will data where Group1 has Yes value

[larsheinemann · Accepted solution]

you would need to either coalesce the fields or better even unpivot them into a single, new column