Forum Discussion

megavic's avatar
megavic
Advocate 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.

megavic's avatar
megavic
Advocate II
10 years ago

Thanks Anonymous,

 

I think the issue with I have with that idea is that I don't have a 'month' field.

 

I'll have a look at what I can do to manipulate the data before it gets in to Power BI.

 

Thanks again,

 

Andy

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
    Advocate 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: