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.
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. Any suggestions on how to remedy this problem?
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.