Forum Discussion
Solved
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 n...
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
Just change the Table visual for a Matrix, there you have an option to switch values.