Forum Discussion
Transpose Table Without "Transpose" Button in Query Editor
I am looking to create a table or matrix visual with dates as the column values. However, in my query, the dates are the row values. This is important since in my main visual (a line and clustered co...
Hello Anonymous
Using a Matrix visual, with your dates on the columns, go to Values > Show on rows and turn it on.
Is that what you are wanting to do?
To clarify, my main goal is not to reformat the output of my query since my main line and clustered column chart visualization relies on the current query output. The main thing I am trying to accomplish is to simply transpose my table visualization (not my table from my query output).
I am talking about making the change only in the Matrix visual.
Here is how my sample matrix visual looks with 'Show on rows' off, each value is a new column under the date:
And with 'Show on rows on'. Each value is on a new row.