Date Filter change sort oder

[Companyuser101]

Hello,

I have a date table which I created like this:

which is a date hierachy 

I have my year filter on filter on all pages:

the sort oder is from the oldest year to the latest. 

How can I change the sort oder? 

So it will start with 2023 and end with 2015. 

Thanks in advance!

[amitchandak · Accepted solution]

@Companyuser101 , Prefer to create a date table and use year column

year = year([Date])

year Rank = rankx(Date, Date[Year],,desc,dense)

Mark year rank as sort column for year and use that

you can create a custom hierarchy if needed

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

[Companyuser101]

Hello,

thank you!

Your recommondation + the youtube Tutorial solved my problem!