Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hello,
From our ERP system I have data on:
[Resource Name] (Machine Centre)
[Project Name]
[Start Date]
[End Date]
# of [Hrs of Work] required
I am trying to make a stacked bar chart that shows each day, with a slicer to filter per [Resource Name], showing which projects are being processed on on the days shown.
Right now I can make a stacked bar with all of the work showing up on the [End Date], but what I need to do is divide the [Hours of work] between the [start date] and the [end date], thus showing how much work is to be done on each project per day.
Thanks,
Solved! Go to Solution.
Thanks amitchandak,
I was able to get the solution to work with some fine tuning. Top graph is what I had before and bottom graph is what I was able to cut it into in terms of daily resource use. Much appreciated!!
Thanks amitchandak, got the date table working but having trouble with the formulas to assign a volume of work per date. Will continue to work on.
User | Count |
---|---|
17 | |
17 | |
15 | |
13 | |
12 |
User | Count |
---|---|
10 | |
8 | |
8 | |
7 | |
6 |