Forum Discussion
How to reorder columns in a Matrix visualization
I have a table that gets distinct values from a date table in the order they'd go in a caledar (what I want). It looks like this
When I use Month & Year as Columns in the matrix, they appear in alphabetical order. How do I make it so that the order from the table carries down?
Anonymous ,
Seems like the column is text type in your table so the matrix will sort the column by the first alphabet letter. You can click query editor and change the column type to date type like below then the matrix will be sorted by date.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- AlB
Community Champion
Hi Anonymous
If you don't have it already create a numerical column YearMonth in your date table (ex. 201901 for Jan-2019) and use trhat column in the Sort by Column option
v-yuta-msftCommunity Support
Anonymous ,
Seems like the column is text type in your table so the matrix will sort the column by the first alphabet letter. You can click query editor and change the column type to date type like below then the matrix will be sorted by date.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
