Put many column as slicer

[supasith]

Dear friend
how can I create a slicer that put more than 1 column (from calculated table) to show data as selected on slicer

Table

Name   Check1   Check2   Check3

John         1              0             1

Marry       0              1             1

Slicer

....Check1

....Check2

....Check3

thank you in advance for any suggestion krub.

[v-xiaotang]

Hi @supasith 

Have you solved this problem yet? If yes, kindly accept✔️ the answer you find useful as the solution.

Or, please provide more details about your problem so that we can work on it further. Thanks.😃

Best Regards,

Community Support Team _ Tang

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

[amitchandak · Accepted solution]

@supasith , There are few ways.

1. Unpivot this table you will get them as row values

https://radacad.com/pivot-and-unpivot-with-power-bi

2. Create a table with distinct value

Distinct(union(distinct(Table[check1]),distinct(Table[check2]),distinct(Table[check3])))

and then join with all three columns. Handle inactive column using userelationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

3.Once Slicer for multiple columns -past solution
https://community.powerbi.com/t5/Desktop/Once-Slicer-for-multiple-columns/td-p/407949