Supply and Demand graph

[rForster]

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

[AppleUSN]

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]

@rForster,

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

Regards,
Lydia

[rForster]

Bump

@v-yuezhe-msft

[v-yuezhe-msft · Accepted solution]

@rForster,

Please check attached PBIX file.

Regards,
Lydia

[rForster]

	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 ?