Forum Discussion
Need help with sorting a visual
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?
3 Replies
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
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.
Hicharbaugh,
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.
