Tornado visualization sort by column not working

[Anonymous]

I am trying to get the Tornado visualization to sort in order by month as it occurs in the calendar year, but I am unable to do so. I created an index column by number to sort that did not work. I changed the index type to text to sort. that did not work. I used the rank function to create another column to sort. This did not work either. Can someone tell me what I am doing wrong? I am a novice so please don't skip anything in your explanation.DataViz

[Anonymous · Accepted solution]

I ended up taking everything out and loading it back up as a table. While in table format, I sorted by the "sort order". Then I changed the visualization type back to tornado. When each column was back in its proper place, the sorting held. Thanks!

[Anonymous]

Hi @Anonymous ,

You can achieve this: 

1: Create a conditional coulmn sort month for e.g. if( [month]= "Jan","1", if ([month]= "Feb","2"),0)

2: Click on month column and in top ribbon you will see sort by column option, please click on sort month
3: Click on the ellipses (...) on right top of your chart and then you can sort by  Sort order

I hope this will solve the issue.

Please mark it at solution if your issue gets solved.

Thank you.

[Anonymous]

Thank you, but that type of sort did not work. I used this method with the column "index sort". Still no change.