Forum Discussion
Resolver IDate table descending year
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!
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
2 Replies
- amitchandak
Super User
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
MoniekThanks, your youtube helps me a lot!!!!!