Unanswered

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

ChartSnap.PNG

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

v-xiaochen-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
Verified answer

ultras0nicducky 18 on at

Like (0)

Report

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

Was this reply helpful? Yes No