Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a matrix visual in a report that has dates as the column headers, and I want them to sort in order by date. Note they currently sort numerically. Can you point me in the rght direction?
Hi@charbaugh,
Please check the data type of the date column, in which case it is most likely the text type.
You can also sort the column in query editor.
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@charbaugh , They are sort Ascending and you want sort descending ?
Create following columns
Date 1 = [date]
Date Rank = rankx(all(Table), [Date])
Sort date1 on date Rank and use it
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
refer my video on this
https://www.youtube.com/watch?v=KK1zu4MBb-c
No. The row that has the dates in it are sorting numerically, so 2/1/20201 2/10/2020 2/11/2021 instead of 2/1/2021 2/2/2021 2/3/2021. I need to sort that row to display in chronological order.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |