Hi, this is my first time to create a pie chart in Power Apps with SharePoint List data.
Currently, I have a SharePoint List named "Learning Tracker" and have a number of column as per below
and when employees completed the courses in Digital Transformation/ One Drive/ Teams, SharePoint List will mark "Completed" and All course will mark "Yes". As per example in excel format below:
I want to have 5 pie charts show that
1. How many "Completed" in Digital Transformation,
2. How many "Completed" in One Drive and
3. How many "Completed" in TEAMS and also
4. how many "Yes" in All course column
5. How many "Yes" in All course and categorise by Region
How can I do so?
hi @Hooi lets go through this and do one for you
This is what we want from the data
(Note i only include the totals for teams, you will have to add the rest). You may also want to create a collection to hold all values whereas i will do the with function in the Items of the Pie chart to illustrate the solution ok.
the PI chart Items =
With(
{
tot: CountRows(colCourses),
teamsTot: CountRows(
Filter(
colCourses,
teams = "Completed"
)
)
},
Table(
{
Name: "Incomplete(" & tot - teamsTot & ")",
Total: tot - teamsTot
},
{
Name: "Complete(" & teamsTot & ")",
Total: teamsTot
}
)
)
Hope this helps
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1