Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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
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!
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
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
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!
Hi v-danhe-msft,
Thank you so much! that's what I need!
You need to unpivot columns
take a look at that
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |