Sorting date in martix-Ascending to Descending

[learner03]

How can I sort date in this view? Below are the rows in Matrix and when I click sort, nothing happens.

For example-In the third customer, date 6 may should come above and 9 may should come after

[amitchandak · Accepted solution]

@learner03 , I think it will take only one sort column, so sort the first one.

For rest use sort column

You can create columns like these

po1# =[PO#] // use in can of you are not able sort po# on Rank

PO# Rank = Rankx(Table, [PO#],,desc,dense)

The sort Po1# on PO# Rank  and use that in visual