Forum Discussion
Solved
Show columns as rows with dynamic columns
Hello, I have a table of values as shown below : I need a report in power bi, for each set of column A, B as columns and C,D,E as rows. For example, For xx, the table should be : ...
Hi steven_osman
In query editor, select column “C”,”D”,”E”, then select Transform->Unpivot Columns-> Unpivot only selected Columns.
Then "close &apply", go to Report View, use these columns in a Matrix visual as below
Best Regards
Maggie
v-juanli-msft
Community Support
Community SupportHi steven_osman
In query editor, select column “C”,”D”,”E”, then select Transform->Unpivot Columns-> Unpivot only selected Columns.
Then "close &apply", go to Report View, use these columns in a Matrix visual as below
Best Regards
Maggie
Thank you it worked :)
