Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
alexc96
New Member

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, 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)

alexc96_0-1695997790361.png

alexc96_1-1695997889373.png

alexc96_0-1696000095867.png

 

 

 

1 REPLY 1
christinepayton
Super User
Super User

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 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.