Forum Discussion

Moniek's avatar
Moniek
Icon for Resolver I rankResolver I
4 years ago
Solved

Date 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 ascend...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    Moniek
    Icon for Resolver I rankResolver I
    4 years ago

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