Sorting a Matrix

[miketom]

I have been trying to sort my report MATRIX from date ascending (Text field) to date descending for many hours. I have tried the sort column by, but the data is so variable and the way weeks have worked over the years has changed makes that virtually impossible. Help!

[amitchandak]

@miketom , Check do you have an option in three dots to do this

In your date calendar create one more date and create desc rank on the date and mark that date column and use that

Date New = 'Date'[Date]

Date Desc Rank = RANKX(all('Date'),'Date'[Date],,Desc,Dense)

Mark the Date Desc Rank  as sort column of Date New and use Date New in your matrix visual

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[miketom]

Apologies, I am lost, are these Measures, Calculated Fields, Other. If I start using DAX it rates them all as 1 due to max, min or average

[V-pazhen-msft]

@miketom 

It was a rough idea to use Rankx, the solution of sorting could be different for cases. It is difficult for us to understand your model just by a few sentences. Can you share a sample pibx which is a straight forward way for us to know your current problem.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[miketom]

My report is a matrix with column headers

WE 2020-01-05 WE 2020-01-12 etc ... to Current Weeks

I simply want to resort it into reverse order