Unanswered

Build a Pie Chart from a SP List

(0) Share

Report

Posted on by RaphaelMelo

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

I have the same question (0)

All responses (2)

Answers (1)

Hassan_SZ_365 542 on at

Like (0)

Report
Re: Build a Pie Chart from a SP List

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

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Build a Pie Chart from a SP List

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")

Was this reply helpful? Yes No