How can I make a pie chart from a SharePoint list? #M365AMA

In this episode, the #M365AMA panel discusses the following community question:

“How can I make a pie chart from a SharePoint list? My Sharepoint list has a column “Compliance”; multiple choice: In Compliance / Attention / Out of Compliance. I want a dashboard page in Powerapps that has a pie chart, showing Compliance status of all units. And next to that a list of vehicles Attention or Out of Compliance . When I add a pie chart – it is not pulling the “Compliance” column as an option and I’m not sure how to write the function correctly? Any help appreciated!”

Check out the discussion here:


Participating in this discussion were:

Some relevant notes/links shared by the team:

Christian Buckley

Christian is a Microsoft Regional Director and M365 Apps & Services MVP, and an award-winning product marketer and technology evangelist, based in Silicon Slopes (Lehi), Utah. He is the Director of North American Partner Management for leading ISV Rencore (, leads content strategy for TekkiGurus, and is an advisor for both revealit.TV and WellnessWits. He hosts the monthly #CollabTalk TweetJam, the weekly #CollabTalk Podcast, and the Microsoft 365 Ask-Me-Anything (#M365AMA) series.