Forum Discussion

magyar's avatar
magyar
Frequent Visitor
9 years ago
Solved

Transpose Values in Table Visual

Hi

 

Could someone please solve this?

 

This needs to be transformed in Table View (or any other visual):

a  b

1  1

 into:

a  1

b  1

 

Many thanks

 

David

Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi magyar,

     

    In your scenario, you can transform the data in Query Editor. Please select those two columns, then click Unpivot Columns.

     

     

    Then apply the change, drag the column Attribute and Value to the table visual. You can download attached .pbix file to have a look.

     

     

    Best Regards,
    QiuyunYu

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi magyar,

     

    In your scenario, you can transform the data in Query Editor. Please select those two columns, then click Unpivot Columns.

     

     

    Then apply the change, drag the column Attribute and Value to the table visual. You can download attached .pbix file to have a look.

     

     

    Best Regards,
    QiuyunYu

    • magyar's avatar
      magyar
      Frequent Visitor
      9 years ago

      Brilliant!

       

      Thanks a lot QiuyunYu for taking the time to answer my question, really appreciated.

       

      David