Forum Discussion

bklyn3's avatar
bklyn3
Advocate II
4 years ago
Solved

Once slicer for multiple boolean columns

Hello 

 

I have a table with 4 columns of type Boolean 

For example : 

 

EventIDAction_AAction_BAction_CAction_D
145TrueFalseFalseFalse
178FalseTrueFalseTrue

 

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

 

1 Reply