Forum Discussion
Pie chart for multiple choice column SPO List
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, ...
christinepayton
Most Valuable Professional
Most Valuable ProfessionalYou 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