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