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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
hibajamal
New Member

Transpose a table made in PBI

Hey guys, I need help with transposing this table in a way that the columns are week and rows are active users, dau etc. 

The thing is these values here are aggregates from different columns. So now I just want this table I've created in the report to be transposed so this 2 x 5 table becomes 5 x 2. 

 

hibajamal_0-1663925703455.png

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@hibajamal https://community.powerbi.com/t5/Quick-Measures-Gallery/TRANSPOSE/m-p/630229#M314

Or

Modify your Matrix so that Week is in your Columns and use the "Show measures/values on rows" functionality.

Greg_Deckler_0-1663927171425.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
hibajamal
New Member

It worked, thanks!

Greg_Deckler
Super User
Super User

@hibajamal https://community.powerbi.com/t5/Quick-Measures-Gallery/TRANSPOSE/m-p/630229#M314

Or

Modify your Matrix so that Week is in your Columns and use the "Show measures/values on rows" functionality.

Greg_Deckler_0-1663927171425.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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