Forum Discussion
Tentoria
2 years agoFrequent Visitor
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...
- 2 years ago
something like this?
lbendlin
2 years agoSuper User
Instead of unpivoting the individual sections separately you need to unpivot all at once.
Can you provide a sanitized extract of your SharePoint list?
Tentoria
2 years agoFrequent Visitor
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