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...
Tentoria's avatar
Tentoria
Frequent Visitor
2 years ago

Hi lbendlin ,

 

Thank you for your reply.

 

I did that and it worked fine for the 1st visual "Collaboration". A soon I did the same for the other 3 visuals (Knowledge, Delivery and Drive) it duplicated the rows resulting to innacurate values in the visuals. So instead of having a total of 18 for each column, it gave 2394 and other higher values. If I click on the row and remove duplicates it removes necessary rows which again results in inaccurate values.

 

Is there a way to share the file with you so you can have a better understanding and maybe fix it?

 

Thank you.

lbendlin's avatar
lbendlin
Super 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:

      • Tentoria's avatar
        Tentoria
        Frequent Visitor
        2 years ago

        Yes!!

        So how can I do it on my dashboard? as the table I have has more columns.

        How can I share with you my pbix file?