cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
v-siky-msft
Community Support
Community Support

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)

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
v-siky-msft
Community Support
Community Support

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)

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

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

Best regards.

Sik

 

Anonymous
Not applicable

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 @Anonymous ,

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

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

Best regards,

Sik

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,291)