Forum Discussion

megavic's avatar
megavic
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Line chart using a table that has multiple fields for x axis

Hi - new Power BI adopter here! I have a table that I'd like a simple line graph for. The issue I have is that the values for the x axis are in individual fields in the table, e.g. PeriodBalance1, P...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Ya, the "shape" of your data is not helping you.  In the query update window thingy (power query) -- check out the UNPIVOT feature, that would change your life.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Ya, the "shape" of your data is not helping you.  In the query update window thingy (power query) -- check out the UNPIVOT feature, that would change your life.

megavic's avatar
megavic
Icon for Advocate II rankAdvocate II
9 years ago

Oh that is sooooo good :smileysurprised:

 

That completely reshapes the query table data and is so simple but powerful!

 

Thank you very much for the suggestion, this is working perfectly.

 

Much appreciated - kudos and accepted answer :smileyhappy: