Forum Discussion
Solved
Data shaping problem
Hello, I wonder if anyone could advise on how best to start transforming this data for analysis/presentation in a pivot or matrix table: I am struggling with the category/value columns. Do I n...
Thanks to your link amitchandak I discovered it's pivot I need on category column, not unpivot! I am a step closer, thank you.
adavid999 , if there are not too many values then you should unpivot. What is the problem you are getting.
If this does not help
https://radacad.com/pivot-and-unpivot-with-power-bi
Refer if these can help
https://docs.microsoft.com/en-us/powerquery-m/table-unpivot
https://community.powerbi.com/t5/Desktop/need-help-with-M-query-to-unpivot/td-p/196255
Thanks to your link amitchandak I discovered it's pivot I need on category column, not unpivot! I am a step closer, thank you.