Forum Discussion
Solved
How to transpose a table in BI?
Hi, I have report on the left side below, all the values are measures. I want to make the table like the one on the right side. I've tried many ways but can't transpose the table....
In the query editor you have to demote your headers first:
and then transpose:
Greg_Deckler
Community Champion
Community ChampionThis looks like a problem for ImkeF.
If you could post sample data in a form rhat can be copied, that would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490