Sort Descending - Matrix Visual

[jcastr02]

I have a matrix visual where I have the date in the columns.  Is there a way I can sort descending so I have the most recent dates on the left vs. having to scroll (July should show on left first).  I tried to go to the data tab and use the "Sort by" but the visual does not change. Any help is appreciated.  See picture.

[v-luwang-msft · Accepted solution]

Hi @jcastr02 ，

Pls refer the following sample I provided:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[jcastr02]

@amitchandak any help is appreciated.  Thank you.

[amitchandak]

@jcastr02 , For that you have create a column with Desc Sort

Date1 = [Date]

Date sort = rankx('Date',[Date],,desc,dense)

Mark Rank Sort as Sort column of Date1 and use date 1 in visual

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

[jcastr02]

Hello @amitchandak   I created a copy of the date column (Date1).  I then created a calculated column for 

Rank Sort = rankx('UPRobotReplenishment',[Date],,desc,dense)

Then I "Sort by Column" for Date1 using Rank Sort and I used Date1 in my visual, but it didn't change the order.