Transpose of a matrix or moving dates to columns

[JamesShawPBI]

Hi Guys,

I have a matrix that displays all my data, execpt I have been asked to put the dates across the page and the data down the page (the transpose of the matrix in the image).

I have tried moving "Date" to Columns field and Values to the "Rows" field but the software won't let me.

Is there a way for me to get dates across the page and the rest of the data going down the page?

Thanks

[PaulDBrown · Accepted solution]

You need to change the Dates field by moving it from the rows bucket to the columns bucket (leave the rows bucket empty):

Next search for "Switch" in the formatting pane and turn on the "Switch values to rows" under Values ->options