Forum Discussion

steven_osman's avatar
steven_osman
Regular Visitor
8 years ago
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 : 

 

 

and for yy the table would be:

 

 

 

Thanks in advance for your help.

Regards,

Steven

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    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

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    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