Forum Discussion

hcze's avatar
hcze
Icon for Helper II rankHelper II
6 years ago
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 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 

 

Need Help

4 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    6 years ago

    hcze 

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

     

    • hcze's avatar
      hcze
      Icon for Helper II rankHelper II
      6 years ago

      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!

       

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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