Transpose Values in Table Visual

[magyar]

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

[v-qiuyu-msft · Accepted solution]

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]

Brilliant!

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

David