Hello, I am trying to create a visual that will show the weekly workload for staff resources across time for a planning tool.
This is the information I have below: Each staff member is assigned to a project size that requires a different level of hours per week of the project and projects are planned for the year.
| Project ID | Staff Resource | Project Size | Planned Start | Planned End |
| 1 | A | Small | 2022-04-03 | 2022-04-17 |
| 2 | A | Medium | 2022-04-10 | 2022-05-08 |
| 3 | B | Medium | 2022-04-03 | 2022-05-01 |
| 4 | B | Medium | 2022-04-24 | 2022-05-22 |
| 5 | B | Large | 2022-05-01 | 2022-07-10 |
| 6 | C | Large | 2022-04-03 | 2022-06-12 |
| 7 | C | Large | 2022-04-24 | 2022-07-03 |
| 8 | C | Medium | 2022-05-15 | 2022-06-12 |
| Hours Required Per Week | |||||||||||
| Project Size | Number of Weeks | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 |
| Small | 2 | 7 | 3 | ||||||||
| Medium | 4 | 5 | 5 | 2 | 3 | ||||||
| Large | 10 | 5 | 3 | 2 | 2 | 1 | 1 | 2 | 3 | 4 | 2 |
Ultimately I want to create a visual with the week number on the x axis and the number of hours required on the y with the staff resource as the values like this
I am struggling to create a measure that will account for the variable time required for each project during the week it runs and then sum it up for the staff resource by the week. Any help or insights on how to do this would be greatly appreciated!
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
| User | Count |
|---|---|
| 134 | |
| 104 | |
| 63 | |
| 60 | |
| 55 |
