How to transpose rows into columns

[Anonymous]

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

[jgeddes]

With the matrix visual have you tried the Switch values to rows option?

[Anonymous]

Just tried. It looks very weird. 

I'd expect a visual like this

[jgeddes · Accepted solution]

If you move your MonthEnding field into the columns cell that will fix it.

[Anonymous]

Oh, It does! Thank you!

[jgeddes]

Are you looking for a result like:

[Anonymous]

Yes, but I have tried Matrix, I only have the date and measures.