cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
maimal80 New Member
New Member

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 

Capture1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Line chart from months in columns

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: Line chart from months in columns

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!