Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |