Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JulietZhu
Helper IV
Helper IV

Transpose row and column in visualization table

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

 

3.PNG

 

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

 

 

4.PNG

 

Dummy data: 

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

1 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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

5 REPLIES 5
Luiggo07
Frequent Visitor

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

JulietZhu
Helper IV
Helper IV

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

@v-shex-msft 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)

Merge Tables 

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.