Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
I have a date filter on my report and I want it to sort the dates in DESC order so the user doesn't have to scroll down to the bottom to get the current month/date. In the data tab I have verified that my field is a DATE datatype and it is sorting in DESC order in the data tab only. How can I get the filter to sort correctly in DESC order?
Solved! Go to Solution.
@clayne , Try think, But then Date will by default sort desc,
Both new column in your table
Date 1 = Date
Rank = rankx(all(Table),[Date],,desc,dense)
Now sort Date1 on Rank. If you try to sort Date it will give dependency error, hence the new column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Use Date1 column
@clayne , Try think, But then Date will by default sort desc,
Both new column in your table
Date 1 = Date
Rank = rankx(all(Table),[Date],,desc,dense)
Now sort Date1 on Rank. If you try to sort Date it will give dependency error, hence the new column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Use Date1 column
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 19 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 52 | |
| 37 | |
| 31 | |
| 27 |