Power Platform Community Forum Thread Details

Hi there,

I have built my first pie chart using some help for the community - thank you.

I used the following formula.

AddColumns(GroupBy(Valuation, "Postcode_x0020_Area", "DATA"), "Count" , CountRows(DATA))

Pie Chart.jpg

I would This shows a count of the number of rows in each postcode areas from the follow list.

Master List.jpg

What I would like to be able to do is show the percentage as the label and not the PostCode Area.

Thanks in advance.

Categories:

Building Power Apps

Hi @LaingBennett! If you want to keep the labels in the legend the same, there isn't a way to show the percentages as the labels. Changing the labels of the pie chart will also change the labels in the legend. The only way I could do something like what you are asking was to make a copy of the pie chart and set the labels for that one as needed, then position it over the first pie chart and set the visibility of the first pie chart to false.

Of course, you will need the percentages as well, which you should be able to find like so:

/* Note: use ##0.0% or ##0.00% instead of ##0% to change the accuracy of your percentages if needed. There will likely be rounding errors where the sum of the percentages don't add up to 100%, depending on your data. */

AddColumns(
 GroupBy(
 Valuation, 
 "Postcode_x0020_Area", 
 "DATA"
 ), 
 "Count",
 CountRows(DATA)
 "Percentage" , 
 Text(CountRows(DATA) / CountRows(Valuation) * 100, "##0%")
)

I hope that makes sense. It's a bit of a hack but unfortunately there aren't many formatting controls for charts in Power Apps. Let me know if that works!