Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
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.
@SomeArmyVet , if possible unpivot the columns in the power query
https://radacad.com/pivot-and-unpivot-with-power-bi
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |