Date slicer Reverse chronology

roger360 , Create three columns with Sort column

Year1 = Year([Date])

Year Sort = Rankx(Date, [Year],,desc,dense)

Month 1= format([Date], "mmm")

Month Sort = Rankx(Date, [Month No],,desc,dense)

Day 1= day([Date])

Day Sort = Rankx(Date, [Day],,desc,dense)

Assume you already have year, month and day

Create new column with sort column. and mark Sort column as sort column for new column

Year sort to marked as sort column for year1. click on Year1 -> go to columns tool and Change Sort order to use Year Sort column 

How to Create Sort Column and Solve Related Errors: 

https://youtu.be/cyWVzAQF9YU?t=39560
https://www.youtube.com/watch?v=KK1zu4MBb-c