Forum Discussion
Date slicer Reverse chronology
Tryting to setup date slicer in reserve chronological order i.e. latest months/dates first (December, November, October...)/(30, 29, 28...).
Was able to do so with the year only by selecting "sort decending" order from more option of the visual.
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
3 Replies
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-cHello roger360 ,
Thank you for reaching out to the Microsoft Fabric Community.
The solution shared by amitchandak is correct. Using calculated columns with RANKX for sorting (e.g., Year, Month, Day) and applying the “Sort by Column” feature ensures your slicer displays values in reverse chronological order as intended.
Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi roger360 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
