Answered

Power Apps Pie Chart - Show Totals in Pie Slices

(1) Share

Report

Posted on by ultras0nicducky

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:

Building Power Apps

All responses (2)

Answers (2)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ultras0nicducky ,

Could you share a sample of your data source?

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

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 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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