Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I'm creating a report based on an SPO list. I want to add a pie chart which contains the most common choices for a multiple choice column. The choices are various M365 Apps, i.e Excel, Word, PowerPoint, Outlook, etc.
If person1 chose Excel & Word and person2 chose Word & PowerPoint, I want the chart to display that Word has 2 values, Excel has 1 and PP has 1.
My choice column is already accepting multiple choices (see 1st img). However, if I add the "M365 Apps" column to my pie chart as Details with the "Name" column as my Values, I get every combination that people have selected (2nd img). If I don't use the "Name" column, all I get is 1 value (3rd img)
You need to split out the values for the field into rows. If you are using the "integrate" feature in the SharePoint UI, it won't let you edit the query directly, so you may need to use the SP Online List connector instead and start fresh. That will let you expand choice value fields to new rows (do this in a separate table and relate the two to avoid row duplication). I did a video explaining how to do this here if it helps: https://youtu.be/LYu3wqb2Nx4
User | Count |
---|---|
136 | |
70 | |
69 | |
54 | |
52 |
User | Count |
---|---|
207 | |
94 | |
64 | |
61 | |
57 |