web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Build a Pie Chart from...

Power Apps

Answered

Build a Pie Chart from a SP List

(0) Share

Report

Report

Posted on by RaphaelMelo

33

Hi, I'm trying to use the piechart control but I cant get it to work.
My chart must show the total of each status of my List.

This is what Im getting when try set it

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Hassan_SZ_365 542 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RaphaelMelo ,
To fix this, you need to aggregate your data based on the status before it's used in the pie chart. Here's a short human explanation of the solution:
Aggregate Data: Ensure the data you're feeding into the pie chart is summarized. You want a count of items for each status.
Adjust Chart Data Source:
Set the pie chart's data source to a version of your list that is grouped by the status column.
Use the "Count" (or similar) aggregation to get the total number of items per status.
Configure the Pie Chart:
For the Values area, use the count of items.
For the Legend (or Category) area, use the status.
Refresh the Chart: After making these adjustments, refresh your pie chart to see if it now reflects the aggregated data.
If you're using Power BI, you might need to use the "Group By" feature in Power Query or create a measure in DAX to count the number of items per status. If it's another tool, look for similar functionality to group and count data based on a column.

Best Regards,
Hassan Raza
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @RaphaelMelo,

Could you please tell me that if this Status column is Text column type?

If so, you just need to set the PieChart Items property as below:

AddColumns(GroupBy(list1,"Status","Gs"),"Count",CountRows(Gs)).Count

Then set the Labels and Series as Count

What's more, set the Legend Items property as below:

GroupBy(list1,"Status","Gs")

Join the conversation