Forum Discussion
Stacking Columns in Power BI
Anonymous here is a quick video on how I implemented it. Make sure all your data types are correct before unpivoting.
https://www.mediafire.com/file/m7shua0kqw0aacs/Unpivot_columns.mp4/file
(this is an instant video link. It may expire over some time)
Let me know if you need any more help on this.
Cheers,
Manendra.
Anonymous , Unpivot the color columns in Power Query
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Power BI: Power Query Functions one must know
: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=36407s
Power BI - Cheat Sheet: Power Query Functions one must know
https://amitchandak.medium.com/cheat-sheet-power-query-functions-one-must-know-a8531b6e321a
Thanks for the guidance. When the Color_1 and Color_2 columns both had colors listed, it worked. However, if only Color_1 has a color, all of the other columns in the data table become filled with "Error" cells. How do I remedy this problem?