convert columns to rows in table vizual or matrix vizual

[Anonymous]

HI
i want to convert rows to columns is it possible in martix or table vizual 
for example i have data like 

Country Codes    amount     profit       loss    
US                       100            20             0
IND                      200           0               60
UK                        300          30             0

i need a data like 
country code     US    IND    UK
Amount            100    200    300
Profit                 20      0       30
Loss                 0         60      0

[v-jincheng-msft · Accepted solution]

Hi @Anonymous ,

Thanks for the information you have given.

Setting up a matrix and set the field "Country Codes" to Columns and the fields "amount", "profit" and "loss" as Values:

In visualization, find visual>values>options and turn on "Switch Values to rows":

And you'll get the results you expect.

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Joseph Ji

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

we have buid the report with the function switch values to rows but How can we export the data into excel with same format. is it possible?
when i am trying to export the data into excel the values are not converting into rows. i need to export the data as per power bi screenshot

excel format 

 power bi 

[kleigh]

If Amount, Profit, Loss are coming from the Values well, try Visual > Values > Options and turn on "Switch values to rows", then set country code as column.

[Anonymous]

do we have any seperate vizual or we can try in table or matrix vizual

[Anonymous]

Thank you I will try 

[kleigh]

This is in the Matrix visual.