Forum Discussion
Anonymous
3 years agoNot applicable
How to transpose rows into columns
Dear All
I have a table visual that comes from the Date table and a few measures. It shows like this. I want to transpose the row into the column. I know if all the data were in the same table I can use unpivot, but how can I achieve this transpose in the current scenario?
Thanks for helping me
If you move your MonthEnding field into the columns cell that will fix it.
6 Replies
- jgeddes
Super User
Are you looking for a result like:
- AnonymousNot applicable
Yes, but I have tried Matrix, I only have the date and measures.
- jgeddes
Super User
With the matrix visual have you tried the Switch values to rows option?
- AnonymousNot applicable
Just tried. It looks very weird.
I'd expect a visual like this
- jgeddes
Super User
If you move your MonthEnding field into the columns cell that will fix it.