Forum Discussion
JulietZhu
Helper IV
Helper IVTranspose 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
JulietZhuHelper IV
Helper IVAnonymous I don't have phyiscal data or table. How can I use pivot or unpivot features? Thanks
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