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

     

v-danhe-msft's avatar
v-danhe-msft
Microsoft 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!