Line chart from months in columns

[maimal80]

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 

[MFelix · Accepted solution]

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