Line Graph

[S-M]

I have a dataset which needs to be displayed as a line graph. The first column shows the company names (redacted in the screenshot) and the other columns show their financial status over the last 12 months.

I need to display this as a line graph showing any upwards or downwars trends in the last year, it will be filtered to only show one company at a time. But when I try to create a line graph using this data, it displays all the data points in a single vertical line.

How can I get this graph to display differently? Nothing I change seems to help.

[tex628]

Hi @S-M ,

Try selecting the "Business Name" column in power query and then use the unpivot columns transformation. It should give you two new column, "Attribute" and "Value". Attribute will hold the period while the value will hold the related value. 

If you then use the Attribute column as the x-axis in the line graph i believe you should get the overview that youre looking for. 

Let me know how it goes! 

Br, 
Johannes

[rohit_singh · Accepted solution]

Hi @S-M ,

Based on your requirements, you will need to first unpivot the data in power query. 

Once that is done, try doing this

Please mark this answer as the solution if it resolves your issue. 
Appreciate your kudos!

Kind regards,

Rohit