Sort matrix column header

[hcze]

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 the result for whatever reasons.

Here I have a simple table with year and index columns and all I wanted to do is just to sort the year descending.

Help appreciated.

Hcze

SortColumnMatrix.pbix 

[Vmpbi]

Thanks for sharing… check out the links below. It provides a comprehensive guide on how to sort measures as columns

in a matrix visual.

https://insurancedatainsights.blog/2024/04/27/dax-topn-brokers-and-others/

Unlock Dynamic Data Display In Your Power BI Matrix

[amitchandak]

@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

[jdbuchanan71 · Accepted solution]

@hcze 

You just have to tell PowerBI to sort your year column by your index column:

[hcze]

Thank you so much! I was under impression that the sorting applied to the whole table but apparently not. I have to click on Year column and sort by Index rather than click on Index column and sort by Index.

The gif is a nice touch and shows small details which otherwise missed!