Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How can I make a bar chart show the number of people that select a singular value in a multi-select field?
In my sample data, I took a sample of 978 records where people have the ability to select more than one value for the same question.
I want the chart to just display either the count or percent of single multi-select values. How can this be done in PowerBI?
Link to Sample Data on Google Doc
I have been struggling to find an answer in the forum, so any way to do this would be greatly appreciated.
Solved! Go to Solution.
Hi @Anonymous,
In your scenario, you can firstly split your [Role] column by comma to Rows in Query Editor.
Then you should be able to simply show [Role] column as Axis, Count of [Unique ID] (with Percent of grand total checked) as Value on the Cluster bar chart to get your expected result.
Here is sample pbix file for your reference.
Regards
Hi @Anonymous,
In your scenario, you can firstly split your [Role] column by comma to Rows in Query Editor.
Then you should be able to simply show [Role] column as Axis, Count of [Unique ID] (with Percent of grand total checked) as Value on the Cluster bar chart to get your expected result.
Here is sample pbix file for your reference.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |