Forum Discussion
Transpose Table Without "Transpose" Button in Query Editor
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?
Hi Anonymous
Is this something that you're after ?
If so, you select all columns except date column and in query editor goto Unpivot Columns --> select unpivot columns. when you unpivot columns will display like , date, Attribute, Value
Then select date column goto Pivot Column tab in the menu ribbon, select the Value in drop down.
All set!
Hi Anonymous , doing this results in a table where each entry is the same value (4.00). In addition, while this is similar to the layout I would like to have in my table or matrix visual, this is not the format I would like to have my query output in since my line and clustered column chart format relies on the original query form where each row represents a specific date.