Forum Discussion
Reshape data to simplify visual plot
Unpivoting as a principle should not be impacted by how many columns you have. I don't think you need to use VBA in preference to Power Querr
I have produced a small sample workbook for you.
https://www.dropbox.com/s/cwcgduqi7efdath/reshape.pbix?dl=1
I unpivoted the data into a different shape that makes the code more efficient. Take a look and see if you can work out how it works. Let me know if you have questions.
Matt
Hi Matt,
Thanks for help, really appreciate it. Actually original file are with many columns with other parameters more than what i provided before, see as attached. That is the reason why i need to find a way to re-shape the data at the 1st place. Perhaps i need to reshape the data using VBA in excel prior import to PBI if DAX is not possible to do it?
Redzuan
Unpivoting as a principle should not be impacted by how many columns you have. I don't think you need to use VBA in preference to Power Querr
Hi Matt,
I managed to automate by using unpivot in data query. This is what i need. Thanks for the solution. Awesome!
Thanks
Redzuan