Why can I not sort my line graph descending on weeknumbers?

[rpinxt]

So this is a simple line graph.

Week 40 to 49. But I wanted to have the latest week, so 49, to show first.

You would think easily to set sorting descending...but:

Nothing there...

Ok thaught I could be creative and in my date table I made a duplicate of the week like :

So line 12 and 13 are equal. Line 12 is my original cannot change that due to other visuals.

But for line 13 I made a different sort by field in line 14.

So I was thinking when I put line 13 on the x-axis and the let that sort by line 14....problem solved.

But nothing of that. When I put in line 14 on the x-axis it starts with -49 so that is good...but ofcourse I do not want it to show -49.

I would think when I sort my x-axis week 40 to 49 by the ISO week desc being -49 to -40 that should work.

Does anybody know what could be the problem?? 🤔

[rpinxt · Accepted solution]

outch...😅.now I know why sorting it by line 14 would not work....

Problem lied within the x-axis type!

You need to set it to Categorical:

Now I got what I need 😁

Ps: This also fixes the part where it shows no sorting options!
So whenever you see no sorting options check your x-axis type 😉