Forum Discussion
Transpose row and column in visualization table
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:
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)
Regards,
Xiaoxin Sheng
5 Replies
Just change the Table visual for a Matrix, there you have an option to switch values.
Can anyboday give clue? Thanks
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
Anonymous I don't have phyiscal data or table. How can I use pivot or unpivot features? Thanks
