Forum Discussion
Solved
Create table/report with each row and one column value
Hi -- I am a PowerBI newbie so thanks in advance for any assistance! I have a data source organized like this: Code ValueA ValueB ValueC ValueD ...ValueAX Code01 0 3 2 0 Cod...
This is much easier in Power Query than you might expect. All you need to do is unpivot the Value columns and filter out the zeros.
See also: https://www.howtoexcel.org/power-query/how-to-unpivot-data-with-power-query/
Wow. This was exactly what I needed. Thank you so much!