web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Create Pie Chart Based...

Power Apps

Answered

Create Pie Chart Based off of One Column

(0) Share

Report

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 Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

DavidZoon 738 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation