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 are:

Client name (unique),

Region (each client is in a preset region of 1-10, with multiple clients in each), 

There is then a column for each month of the current year with the sales figure in each.

 

 

I would like to create a line chart with the months along the x axis, and a line for each different regions but, because each month has its own column, I cannot get it to do this.

 

Can anyone help??

 

Thanks

  • 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

5 Replies

  • 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

    • KatieH's avatar
      KatieH
      Advocate IV
      9 years ago

      This is brilliant!

       

      Thank you so much to both of you for your help:)

    • 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

  • sokg's avatar
    sokg
    Solution Supplier
    9 years ago

    Try unpivot columns in power query.