Forum Discussion

Alex_Ger's avatar
Alex_Ger
New Member
7 years ago
Solved

new dimensions

Hello,

 

I have the excel table looks like this https://prnt.sc/l7fv1z and I want to create a chart like this https://prnt.sc/l7fuqr.

How can I do it?

 

Thank you in advance!

  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Alex_Ger,

    Based on my test, you could refer to below steps in query editor:

    Choose the value column(Jan-plan,Jan-Actual,Feb-plan,Feb-Actual....) and use the Unpivot columns function:

    Use the 'split columns' function:

    Result:

    Apply it and create your desired visual:

    You could also dowanload the pbix file to have a view.

     

    Regards,

    Daniel He

     

6 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Alex_Ger,

    Based on my test, you could refer to below steps in query editor:

    Choose the value column(Jan-plan,Jan-Actual,Feb-plan,Feb-Actual....) and use the Unpivot columns function:

    Use the 'split columns' function:

    Result:

    Apply it and create your desired visual:

    You could also dowanload the pbix file to have a view.

     

    Regards,

    Daniel He

     

    • Alex_Ger's avatar
      Alex_Ger
      New Member
      7 years ago

      Hi v-danhe-msft,

       

      Thank you so much! that's what I need!

       

       

    • Alex_Ger's avatar
      Alex_Ger
      New Member
      7 years ago

      Hi again v-danhe-msft,

       

      could you please tell me how do I now properly sort the months. I found only A-Z, Z-A and months/values sort, but months are here strings , not in date format. 

       

      Thank you!

       

       

    • v-lili6-msft's avatar
      v-lili6-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      hi, Alex_Ger

      You can use Unpivot Function in Edit Queries as below:

      Step1:

      Select all Plan and Actual column then click Transform->Unpovit columns

      Step2:

      Select Attribute column click Column From Example then enter value "Plan"  and then click "OK"

       

       

      Step3:

      Close&Apply

      Drag Attribute field into Axis and Value field into Value and Text After Delimiter field into Legend

      Best Regards,

      Lin

       

       

      1