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
EricHD
Frequent Visitor

Graph Date on x-axis when column headers are dates

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:

RegionTeamProjectFY23 Actual202301FY24 Actual202401....
JapanTeam 1Project 210050200100 
USATeam 2Project 12007040060 

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!

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@EricHD 

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

11.png12.PNG

 

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@EricHD 

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

11.png12.PNG

 

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.