Sort by not working

[qmartiny]

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

[v-jayw-msft · Accepted solution]

Hi @qmartiny ,

Create a index column or rank column.

Add this column to tooltips.

Then sort the visual by this column.

Best Regards,

Jay

[HotChilli]

"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 

[qmartiny]

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