Forum Discussion
Sort by not working
Hello
I am trying to sort ascending by week number (see below)
I created a column with just the week number, set it as whole number, add it as a tooltip and use sort on it.
Still doesn't work - see week 10
Any ideas?
Thank you so much
Hi qmartiny ,
Create a index column or rank column.
Add this column to tooltips.
Then sort the visual by this column.
Best Regards,
Jay
3 Replies
"I created a measure" - you need to use the 'sort by column' feature. Add a column which reflects the sort order required for the x-axis fields (w1, w2), make it a number.
Search 'sort by column' if you get into difficulty
Yeah sorry I misspoke
It's already a column.
What's strange is when I use that column as continuous it works
But not categorical, maybe that's the issue? I need the 'W' in front of number ideally
Hi qmartiny ,
Create a index column or rank column.
Add this column to tooltips.
Then sort the visual by this column.
Best Regards,
Jay
