Graph Date on x-axis when column headers are dates

[EricHD]

I have an expense/budget table where descriptions are listed by column and yearly/monthly actual, forecast and budgeted financial information as headers as shown below:

Region	Team	Project	FY23 Actual	202301	FY24 Actual	202401	....
Japan	Team 1	Project 2	100	50	200	100
USA	Team 2	Project 1	200	70	400	60

and so on... the column headers continue on for each month for the fiscal year. The values in each yearly/monthly column is a financial value.

I'm trying to graph and create visuals where the x-axis would represent said years / months and the financial sum / calculations are plotted as Y value. 

Is there a way to do this?

Apologies if this is solved somewhere else but any direction would be greatly appreciated!

[ryan_mayu · Accepted solution]

@EricHD 

in pq ,select the first 3 column and unpivot others. then all the date data will be in one column

not sure what's the expected output based on the sample data you provided. Hope this can help to point the right direction for you.

[EricHD]

@ryan_mayu 
Thank you so much for your swift response and solution!

[ryan_mayu]

you are welcome