Forum Discussion
Sorting Axis on Line Graph by Month Starting in August to July
Hi ironeagleuk ,
You don't need to put the sort column in the visualization, what you need to do is to pick the column you want to have sorted by a different column in this case the ShortMonth and then on the sort by column select the MonthSort column.
This will automatically sort your short month by the number and not by text. Be aware that when you do this you probably will need to take the column ShortMonth from the axis and replace it because some times the sorting does not take immediate effect on the visualizations that are already created.
When I do this ussually I hide the Sort column so I don't get confused building my visualizations.
ironeagleuk , Setup seems correct. I noticted both times you click on the "month sort" column and showing sorting on month sort column.
You need to click on the smallmonth column and sort on the month sort column.
Please check again. This what I am seeing in screenshots.
amitchandak MFelix Thanks to both of you.
I thought I only had to click on the Column I wanted to sort by in the Fields list, and again click that same field in the Sort By Column dropdown.
But selecting SmallMonth in the fields list, then selecting MonthSort in the drop down Sort By Column indeed did work
Thanks again, I must have missed something in previous solutions.
Super UserThe Sort Column by is regarding a single column not the all table on your model, so you can have several columns in the same table and the sorting be different for each other.
Glad you were abble to solve it.