Need help with sorting a visual

[charbaugh]

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?

[Anonymous]

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.

[amitchandak]

@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

[charbaugh]

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.