Transpose row and column in visualization table

[JulietZhu]

I have visualization table from different tables. which you can see below.

But I need switch row and columns in order to plot 100% stack column chart based on payer name. Since 

it is not physical table exsiting, I can't do transpose table or pivot table. Please give some suggestion and clue. Thanks

Dummy data: 

https://1drv.ms/u/s!AlYpYKwSuOKxhFCytsL0nAuDszJ2

[Luiggo07]

Just change the Table visual for a Matrix, there you have an option to switch values.

[JulietZhu]

Can anyboday give  clue?  Thanks

[Anonymous]

Hi @JulietZhu,

Current data view side not contains feature to transpose row/columns.

I'd like to suggest you enter to query editor to use unpivot column feature to transform your tables. 

Unpivot Data Using Excel Power Query

Regards,

Xiaoxin Sheng

[JulietZhu]

@Anonymous I don't have phyiscal data or table. How can I use pivot or unpivot features? Thanks

[Anonymous · Accepted solution]

Hi @JulietZhu,

You can take a look at following link to know how to use relationship keys to merge tables, then do 'unpivot columns' on merge new table.

Combine data from multiple data sources (Power Query)

Merge Tables 

Regards,

Xiaoxin Sheng