Answered

Need help with PieChart

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am new to powerapps. I just want to create a pie chart or bar chart in PowerApps that is linked to a sharepoint list column called status that will count the number of times the following records occur.

Under Review
Hold
Submitted
Not Started
In Progress/On track
Will Not Implement
Complete

I have looked everywhere and I can't make it work. Can anyone please help?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this in the Advance Data section of the Pie Chart.

Items > AddColumns('SPListName', "Count", 1)

Labels > Status

Series > Count

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Its counting all of them as one. Is there a way to group them and count?

Was this reply helpful? Yes No
billw 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@Becca51178
Under advanced, make sure you have the Label and Series pointing to the correct fields.
Also make sure your Item Color Set does indeed have different colors, and enough colors for each category

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

OK, lets try this again but this time we'll group the statuses together and aggregate the count.

Items > AddColumns(GroupBy(AddColumns('SPListName', "Count", 1), "Status", "Counts"), "Total",Sum(Counts, Count))
Labels > Status
Series > Total

Was this reply helpful? Yes No