Forum Discussion

EricHD's avatar
EricHD
Frequent Visitor
2 years ago
Solved

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: Region Team Project FY2...
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    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's avatar
EricHD
Frequent Visitor
2 years ago

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

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

you are welcome