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. can you help me?
In the query editor you have to demote your headers first:
and then transpose:
2 Replies
- ImkeF
Community Champion
In the query editor you have to demote your headers first:
and then transpose:
- Greg_Deckler
This 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
