Forum Discussion
Solved
Sort matrix column header
Hi all, First of all, my apology since I have seen the same question had been posted numerous times and all answers are leading to creating new index/sort column, however I cannot seem to replicate ...
hcze , On Matrix column there is not sorting available. It means your default sorting will stay. And that is Ascending. The way to do is create a Year Desc Rank Like this
Assume you have Year column in date table
Year = Year([Date]) // Similar formula -- This is column you alredy have
Year1 = Year([Date]) // new column to avoid circular depndencies
Year Rank = Rankx(All(Date),[Year1],,Desc,Dense) // Desc sort
Mark Year Rank sort column of Year.
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column