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 

[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!