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

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