Forum Discussion

Tentoria's avatar
Tentoria
Frequent Visitor
2 years ago
Solved

Power BI count unique values in a column from SharePoint list

Hi everyone,   I have a SharePoint list with multiple (choice) columns, each column has different values (C/CWF/DEV/NA). I want to divide the columns into 4 different bar charts where every chart d...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

Tentoria's avatar
Tentoria
Frequent Visitor
2 years ago

Hi lbendlin ,

 

FTT NAMEPTT NAMEPTT GRADEDATECOLLABORATIONProactively supports co-trainer(s)Follows lead trainer guidance /decisionsCommunicates with lead trainer in a timely mannerKNOWLEDGEDelivers correct SEP knowledgeAble to provide additional knowledge (apart from the OME)Answers questions confidently and knowledgeably DELIVERYAble to objectively evaluate leaner(s) performanceAble to respectfully deliver objective /constructive feedback to learners during the practical sessionsRespectfully deliver theory sessionsCommunicates with learners appropriatelyAdheres to approved timetable /training material(s)Manages all training resources efficiently
HusseinAhmed PUR07/12/2023 00:00:00 CCC CCC CCCCCC
HusseinEl IasGR106/12/2023 00:00:00 CWFCWFCWF CCC CCCCCC
HusseinWissam CSV08/12/2023 00:00:00 CCC CCC CCCCCC
Tilina Yvonne PUR08/12/2023 00:00:00 CCC CCC CCCCCC
Tufan Roxanne PUR08/12/2023 00:00:00 CCCWF CCC CWFCCCCC
Trevor Saba CSV08/12/2023 00:00:00 CCC CWFCWFCWF CCCCCC
Xiyao Sean PUR01/12/2023 00:00:00 CCC CCC CCCCCC
Wael Francesca  GR107/12/2023 00:00:00 DEVCC CCC CCCCCC
Mary Mijat PUR08/12/2023 00:00:00 CCC CCC CCCCCC
HusseinMichael PUR08/12/2023 00:00:00 CCC CCC CCCCCC
HusseinJanka CSV08/12/2023 00:00:00 CCC CCC CCCCCC
HusseinDeon PUR08/12/2023 00:00:00 CCC CCC CCCCCC
HusseinManpreet PUR08/12/2023 00:00:00 CCC CCC CCCCCC
Orsolya Maleena GR108/12/2023 00:00:00 CCC CCWFC CCCCCC
Christian AhmedPUR27/12/2023 00:00:00 CCC DEVCWFC CCCCCC
HusseinAlexandra CSV27/12/2023 00:00:00 CCC CCC CCWFCCCWFC
HusseinShauna  FG103/01/2024 00:00:00 CCC CCWFDEV CCCCCCWF
HusseinLejla FG110/01/2024 00:00:00 CCC CWFCWFC DEVCCCCC
HusseinAnnaGR111/01/2024 00:00:00 CCC CCC CCCCCWFC

 

This is the table before unpivoting as I couldn't upload it due to the duplicates. Please unpivot the columns and see the duplicates.

 

Desired outcome: