Sort by column in the visual matrix . ?

[suvechha]

Hi All,

I have a matrix with Day Month as column and all the other as values - How can I sort the Day Month Ascending ?

I dont have any option to sort by Day Month .

[amitchandak]

@suvechha , In Nov 2021, few options are added. Else you can create a new column with a new sort

Month Date = [Date Month]

Month Date Sort = format([Date], "MMDD")

If needed create rank

Month DateRank = rankx('Date',[Month Date Sort])

Mark them Month Date Sort or Month Date Rank as sot column of the new copy column and use that

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c