Forum Discussion
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...
something like this?
The process is the same, regardless of how many columns you have.
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
Here is the link to the file.Thank you and Happy new year 🙂
Instead of unpivoting the individual sections separately you need to unpivot all at once.
Can you provide a sanitized extract of your SharePoint list?
Hi lbendlin ,
I tried unpivoting all at once but how do I select which ones go in each visual?
Here is the link to sharepoint list : https://we.tl/t-I097XfqURB
No, I have to check how to hande list templates, a first for me.
Appreciate your help 🙂