Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
rForster
New Member

Supply and Demand graph

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

1 ACCEPTED SOLUTION

@rForster,

Please check attached PBIX file.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
AppleUSN
Frequent Visitor

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.

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@rForster,


Please help to share sample data of your table and post expected result here.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@rForster,

Please check attached PBIX file.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 JulyAugustSeptemberOctoberNovemberDecember
Supply (hrs)460460460460460460
       
Demand (hrs)      
company 1200200200200200200
company 2200200200200200200
       
company 310200000
company 41800000
company 52016040   
company 62016020000
       
       
       
Total demand468740460400400400
       
Hours-8-2800606060
       
Engineers over/under-0.05-1.7500.3750.3750.375

 

 

Need someone of showing this information in a graph format is there any way ?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.