Once slicer for multiple boolean columns

[bklyn3]

Hello 

I have a table with 4 columns of type Boolean 

For example : 

EventID	Action_A	Action_B	Action_C	Action_D
145	True	False	False	False
178	False	True	False	True

Is there a way to create one slicer that would show 

Action_A

Action_B

Action_C

Action_D 

So that the use can filter out the data by selecting Action A, Action_B, Action_C or Action_D and the result would be a table where a line with any of the action select would show if any of the action is True (i.e. as long as a selected Action is True, the line shows) 

For instance if user select Action_ A and Action_C in the example above  The event 145 would show because Action_A is True (even if Action_C is False).  

If the user select Action_A and Action_B both event would show etc..

Thanks for your help

P 

[amitchandak · Accepted solution]

@bklyn3 , One way is to unpivot the 4 columns in power query

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

Another is to have one table with true-false values, join it with all 4 columns, and then create measures using userelationship

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

You can create a measure slicer using field parameters

https://medium.com/@amitchandak/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9a...