Forum Discussion
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!
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
rafaelmpsantos
Responsive Resident
Responsive ResidentYou need to unpivot columns
take a look at that