Answered

How to show percentage of total in a Pie Chart

(0) Share

Report

Posted on by Vw123

I have managed to get the proportions of different organizations to show on a pie chart with the following formula in the items section of the chart:

AddColumns(
 AddColumns(
 GroupBy(
 Ungroup(
 Filter('Conflict of interest', 'Record Status'.Value = "Active"),
 "NamesoforganizationsIbelongto"
 ),
 "Value",
 "Organization"
 ),
 "count",
 CountRows(Organization)
 ),
 "Label",
 Value & " (" & Text(count) & ")"
)

It produces the following table:

Label	Organization	Value	count
Organization A (1)	[Table]	Organization A	1
Organization B (1)	[Table]	Organization B	1
None	[Table]	None	1

I want to calculate and show on the pie chart what the proportion is of the 'count' column where the 'Value' is not "None". In the example above it would be 2/3 or 67% and I want to show this on the chart. Any help is much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

CarlosFigueira on at

Like (1)

Report
If you move that formula from the Items property to a named formula, similar to the one below:

GroupedItems = AddColumns( AddColumns( GroupBy( Ungroup( Filter('Conflict of interest', 'Record Status'.Value = "Active"), "NamesoforganizationsIbelongto" ), "Value", "Organization" ), "count", CountRows(Organization) ), "Label", Value & " (" & Text(count) & ")" );

Then you can set the Items property of the pie chart to 'GroupedItems', and then add a label next to it with an expression similar to the one below:

"Other than none: " & Round(100 * CountIf(GroupedItems, Value <> "None") / CountRows(GroupedItems), 0)

Hope this helps!

Was this reply helpful? Yes No
SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report

@Vw123

Please check my recent blog about Named Formulas: Unlocking the Power of Named Formulas in Power Apps

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Vw123 35 on at

Like (0)

Report

Thank you for the answers. Maybe I formulated my question a bit weird, but I would like the pie chart to show the proportion of how many people are connected to one or more organizations out of the total population. There are also some people who don't belong to any organizations in my data, hence "Value" column = None. In the example above there is 3 people in total and two of them belong to organizations.

Was this reply helpful? Yes No