Forum Discussion
Sorting a Matrix
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
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
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.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