Create Pie Chart Based off of One Column

(0) Share

Report

Posted on by gjbannister01

185

Hello!

I have created an app in Power Apps. However, I am wanting to add a pie chart with data from one column, where each slice is of the different column choices. For example, if my column is Unit, and the choices are "Unit 1", Unit 2", "Unit 3", then those three units will be given each slice. I have 30 units, and I am wanting to calculate how many items have selected their respective unit.

So an example of one slice would be:

"Unit 1" - 8(number of items with "Unit 1" selected")

"Unit 2" - 7

"Unit 3" - 4

"Unit 5" - 23

etc....

FYI, I do not have a column in my list for the number of items from each choice. I would have to do "AddColumn" or something. I just have a column for Unit.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

DavidZoon 738 Most Valuable Professional on at

Like (1)

Report
Hello,

You can achieve your goal by combining AddColumns(), GroupBy() and CountRows() functions, here is an example :

AddColumns( GroupBy( AddColumns( 'Sample List', "ChoiceValue", Choice.Value ), "ChoiceValue", "Detail" ), "Count", CountRows(ThisRecord.Detail) )

The result is a table of Distinct Choices values in a list ('Sample List') and a column is added to count how many times each value appears in the list

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.

Was this reply helpful? Yes No
gjbannister01 185 on at

Like (0)

Report

Perfect!!! That worked. Thank you so much!

Was this reply helpful? Yes No