Forum Discussion

KatieH's avatar
KatieH
Advocate IV
9 years ago
Solved

Line Chart with Months per Column

HI all,   I am a beginner user on Power BI and would really appreciate some help.   I have inherited some excel reports and need to create some dashboards off the back of them.    The columns a...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi KatieH,

     

    As sokg said, you can simple to unpivot column function to achieve your requirement.

     

    Steps:

    1. Select these month column.
    2. Click "unpivot columns" button to convert these columns to "Attribute" and "Value" columns.
    3. Create line chart adn drag "Attribute" to Axis, "Region" to legend, "Value" to Values fileds.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi KatieH,

 

As sokg said, you can simple to unpivot column function to achieve your requirement.

 

Steps:

1. Select these month column.
2. Click "unpivot columns" button to convert these columns to "Attribute" and "Value" columns.
3. Create line chart adn drag "Attribute" to Axis, "Region" to legend, "Value" to Values fileds.

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

It works.

 

And how to sort data month wise in this chart? e.g. Jan, Feb, March way rather than alphabetical sort? 

  • omelo's avatar
    omelo
    Helper III
    5 years ago

    Did you manage to get the sorting working?

    I'm looking for a solution!

     

    Thank you