web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power Apps Pie Chart -...
Power Apps
Unanswered

Power Apps Pie Chart - Show Totals in Pie Slices

(1) ShareShare
ReportReport
Posted on by 18

Hello,

I have a chart that pulls data from one column.  The column name is "Results" which is populated with either "Compliant", "Not Compliant" or "N/A".  I used the below formula in Items for the pie chart but have three problems:

 

1.  The pie chart slices are evenly divided between the three responses regardless on how many items are in each response.

2.  I cannot figure out how to have the pie chart slices to show the total in the each slice.  If this isn't possible can I get the totals to be added to the label?

3.  I have a delegation warning for large data sets (My list will only have <40 items)

 

Items = AddColumns(GroupBy('SharePointListName',"Results","GroupedByResult"),"Count",CountRows('SharePointListName'))

 

Any help is truly appreciated!

Categories:
I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    on at

    Hi @ultras0nicducky ,

     

    Could you share a sample of your data source?

    Assuming 'Results' is a text field, I made a sample for you.

    vxiaochenmsft_0-1668577987007.png

    vxiaochenmsft_1-1668578010307.png

    AddColumns( AddColumns( GroupBy(LIST289,"Results","GroupedByResult"),"Count",CountRows(GroupedByResult)),"New Name",Results&" "&Count)

     

    For your third question:

    Don't worry. It doesn't matter if you have only<40 items.

     

    Best Regards,

    Wearsky

  • Verified answer
    ultras0nicducky Profile Picture
    18 on at

    Thank Wearsky!  It worked without issue.  Have a great day!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 840 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 332 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 275

Last 30 days Overall leaderboard