This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 27 | |
| 26 | |
| 22 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 48 | |
| 46 | |
| 41 | |
| 21 | |
| 18 |