Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 ?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |