Forum Discussion

maimal80's avatar
maimal80
New Member
9 years ago
Solved

Line chart from months in columns

Hi, 

Quite new to power bi, trying to do a simple line chart from the sample data above (for one item at a time such as a chart for depreciation) with months in the x axis. can do all sorts of visualisations but not line chart. apparently data is not organised (i.e. months are in columns and line chart doesn't support by default). Any work around? would really appreciate - have spent a few hours researching already - no luck yet.

Thanks 

  • HI maimal80,

     

    You need to go to que query Editor and chose the columns of the months and unpivot them this will give you your information in a tabular way that the column chart can use easily.

     

    Regards,

    MFelix

1 Reply

  • HI maimal80,

     

    You need to go to que query Editor and chose the columns of the months and unpivot them this will give you your information in a tabular way that the column chart can use easily.

     

    Regards,

    MFelix