Answered

Using Data from SP list to populate pie chart

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good Morning everyone,

I'm not really sure where to start with this one but I know what I want to do 😅. I am creating a project management app and would like to have a screen where the user would select an employee from a drop down, causing a pie chart to populate their total hours worked on the various projects they are assigned. I've been searching around the interweb and can't find anything that resembles what I'm trying to accomplish.

My SP list "Project Time System" contains columns "Project" "Name"(Employee), "Monday" - "Sunday" (user can enter hours spent by day), and a total hours column that sums the hours in Monday - Sunday columns

The other SP list is a simple list of employees which I use to populate the drop down

Any push in any direction would be greatly appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Some example data will be helpful for us to provide further assistant.
The pie chart is to show the total hours on each project of the selected employee. If the Total hour column is the total hours that employee worked on the project(each project only has one row) , you can just set the series property of Pie Chart to 'Total hours' column, and Set the items of Pie Chart as below:
Filter('SP list',Name=Dropdown1.Selected.EmployeeName)
If this doesn't make sense, please let me know.
Best regards.
Sik

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

Like (0)

Report
Copy link

Link copied!

That worked, thank you - one more thing before I check this as the solution - How do you change the labels on legend - just says "Item(1), Item(2)

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
Modify the Labels property of PieChart, please check the screenshot:
Best regards,
Sik

Was this reply helpful? Yes No