Date table descending year

[Moniek]

Hi, I have creating a date table with calenderauto. And now, I was made a matrix, with rows months and colums for years. But I want to sort the years descending, by default they are sorting by ascending. Can anyone tell my how to sort the years descending. Thank you!

[amitchandak · Accepted solution]

@Moniek , For Matrix I doubt still option is not added. Option not added bar/stacked legends in Nov 2021.

You need to create these columns in table/date table

Year 1 = [Year])

Year Order  = rankx('Date', [Year],,desc,dense)

Mark Year sort as sort column of the year and use that

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[Moniek]

Thanks, your youtube helps me a lot!!!!!