Help turning 8 yes/no columns into a single slicer

[SomeArmyVet]

Hi Pbi Community, 

I have a SP List with 8 different trainings that employees can be certified in. These columns are yes/no choice. 

Training 1	Training 2	Training 3	Training 4	Training 5	Training 6	Training 7	Training 8
Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
No	No	No	No	No	No	No	No

Is there a way to make a combined horizontal slicer with each training listed? Example below...

Training 1

Training 2

Training 3

Training 4

Training 5

Training 6

Training 7

Training 8

The filter would only need to show the employees with "Yes" when the training name is selected, but also show the employees when more than one training is selected. ie Show who has training 1 and training 5 combined or 1,2,3 or any combo that can be thought of.

Thank you for your time! 

[Anonymous · Accepted solution]

Hi @SomeArmyVet ,

As @amitchandak mentioned, please firstly use "Unpivot" to transform the table:

Create a flag measure——if all value are Yes, then 1 else 0.

Flag filter = 
var _t= SUMMARIZE(FILTER(ALLSELECTED('Table'),[Employee]=MAX('Table'[Employee])),[Value])
return IF( "No" in _t,0,1)

Then apply it to filter pane, set as "=1" , below is the output:

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

[amitchandak]

@SomeArmyVet , if possible unpivot the columns in the power query

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