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 displays on the X axis the names of the columns and the Y axis displays the bars where each bar shows the total number of different values in that specific column so I guess the bar would have 4 different colors. 

Below is the table (it has more columns):

 

I want something similar to the below, basically I will need to create 4 of the below.

 

It is important that the charts update whnever a new entry is added to the list.

 

Thank you and I loof forward to your support.

 

15 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

    Do not include sensitive information or anything not related to the issue or question.

    If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

    Please show the expected outcome based on the sample data you provided.

    Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

    • Tentoria's avatar
      Tentoria
      Frequent Visitor
      2 years ago
      FTT NAMEPTT NAMEPTT GRADEDATEProactively supports co-trainer(s)Follows lead trainer guidance /decisionsCommunicates with lead trainer in a timely manner
      User 1PTT1PUR45267CCC
      User 1PTT2GR145266.3333CWFCWFCWF
      User 1PTT3CSV45268CCC
      User 2PTT4PUR45268CCC
      User 3PTT5PUR45268CCCWF
      User 4PTT6CSV45268CCC
      User 5PTT7PUR45261CCC
      User 6PTT8GR145267.3333DEVCC
      User 7PTT9PUR45268CCC
      User 1PTT10PUR45268CCC
      User 1PTT11CSV45268CCC
      User 3PTT2PUR45268CCC
      User 2PTT12PUR45268CCC
      User 8PTT13GR145268CCC
      User 9PTT1PUR45287CCC
      User 4PTT14CSV45287CCC
      User 5PTT15FG145294CCC
      User 2PTT16FG145301CCC

       

      Thank you for your reply lbendlin .

      Above is a sample data of a bigger table that I have on the SharePoint list. Out of this data I am generating a Power BI dashboard like the below:

       

      Everything is ok on the dashboard except for the 4 visuals (Collaboration, Knowledge, Delivery and Drive). Based on the sample table provided, the last 3 columns are under the collaboration visual which I want it to display like the visual below:

       

      Help me with that and I will follow the same for the other 3 visuals.

       

      Let me know if you need any more information.

       

      Thank you 🙂