cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Using Data from SP list to populate pie chart

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @mattn4962 ,

 

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)

Snipaste_2019-12-09_14-49-07.png

If this doesn't make sense, please let me know.

Best regards.

Sik

 

View solution in original post

3 REPLIES 3
Community Support
Community Support

Hi @mattn4962 ,

 

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)

Snipaste_2019-12-09_14-49-07.png

If this doesn't make sense, please let me know.

Best regards.

Sik

 

View solution in original post

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)

Hi @mattn4962 ,

Modify the Labels property of PieChart, please check the screenshot:

Snipaste_2019-12-10_09-42-54.png

Best regards,

Sik

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,969)