Unanswered

Pie Charts Single Column

(0) Share

Report

Posted on by zapperrr

Hi, I was playing around with the pie chart and I was wondering if it would it be possible to create a pie chart that only counts the values in one column?

For instance, I want to show a pie chart that collects all the different types of equipment (Equipment Type) and displays them with numbers on the pie chart.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @zapperrr

Using the below formula for the Items property of the PieChart control, you should get a count of each type of equipment:

AddColumns( GroupBy( DataSource, "Equipment", "GroupedByEquipment" ), "Count", CountRows(DataSource) )
zapperrr 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey, thanks for the response.

Unfortunately, this didn't work. Would I have to specify if it's a value column? The name of the column is Equipment Type but it doesn't seem to be working when I add in my own things.
rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @zapperrr

try

AddColumns( GroupBy( yourDataSource, "your Column", //Equipement "Different Equipment" //Group name for all the equipment ), "Total", CountRows('Different Equipment') //count the group name )

Result

Creating a collection as data source to illustrate

ClearCollect(colSomeSource01, ForAll(Sequence(20),{equip: "Equipment Type " & RandBetween(1,3), 'Anohter Column': Value}))

AddColumns(
GroupBy(
colSomeSource01,
"equip",
"Different Equipment"
),
"Total",
CountRows('Different Equipment')
)

Hope this helps,

R
BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @zapperrr ,

To make this work for a complex type column such as Choice, you have to add a column to the data source that holds the value and then group by that:

AddColumns( GroupBy( AddColumns( DataSource, "vEquipment", Equipment.Value ), "vEquipment", "GroupedByvEquipment" ), "CountEquipment", CountRows(GroupedByvEquipment) )