Show columns as rows with dynamic columns

[steven_osman]

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 : 

 

and for yy the table would be:

 

Thanks in advance for your help.

Regards,

Steven

[v-juanli-msft · Accepted solution]

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

[steven_osman]

Thank you it worked 🙂