Forum Discussion
Data shaping problem
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.
Thanks amitchandak do you mean unpivot on the category and value column (there are not too many categories - 17). When i try this I don't get the results I expect. I will look at the links you sent, thank you.