Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a bunch of data
Supply of hours avaialbe to be burned
Demand coming from different companies with different hours
With calculations of extra resources needed to meet the demand
Scoping out over the next 6-12 months
Have all this data but dont know a good way to display it in a graph. Any ideas ?
Thanks
Solved! Go to Solution.
@rForster,
Please check attached PBIX file.
Regards,
Lydia
I found an issue with this answer. If the supply value is not the same from month to month then this process does not work. The value of the supply stays constant because the date being used is from the Company table where the demand is at. The matrix doesnt know that the values changed for the same date on the supply table. I am trying to figure this out myself for my own data and having a heck of a time.
Please help to share sample data of your table and post expected result here.
Regards,
Lydia
@rForster,
Please check attached PBIX file.
Regards,
Lydia
July | August | September | October | November | December | |
Supply (hrs) | 460 | 460 | 460 | 460 | 460 | 460 |
Demand (hrs) | ||||||
company 1 | 200 | 200 | 200 | 200 | 200 | 200 |
company 2 | 200 | 200 | 200 | 200 | 200 | 200 |
company 3 | 10 | 20 | 0 | 0 | 0 | 0 |
company 4 | 18 | 0 | 0 | 0 | 0 | 0 |
company 5 | 20 | 160 | 40 | |||
company 6 | 20 | 160 | 20 | 0 | 0 | 0 |
Total demand | 468 | 740 | 460 | 400 | 400 | 400 |
Hours | -8 | -280 | 0 | 60 | 60 | 60 |
Engineers over/under | -0.05 | -1.75 | 0 | 0.375 | 0.375 | 0.375 |
Need someone of showing this information in a graph format is there any way ?
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |