SORT MATRIX BY YEAR AND SHOW YEARS IN THE COLUMN

[MS3]

Hi!

I am trying to do a matrix that contains the years 2017, 2018 and 2019. It is sorting the years in this order (2017, 2018 and 2019). I want the order to be 2019, 2018 and 2017.

I have used the function of Rank - as suggested in a similar post- to create an additional column in my table with the Rank. The same succesusfuly has put the Rank as 1 for 2019 2 for 2018 and 3 for 2017.

If I select the column Rank in my matrix, yes I can see the years ordered as 1, 2 and 3. The catch is the name of the column is 1,2 and 3, but I would still like this to be 2019, 2018, and 2017.

Is there a way to ensure the order is 2019, 2018 and 2017, but that these are the labels in the Column?

The help is much appreciated.

[v-lid-msft · Accepted solution]

Hi @MS3 ,

We can try to create two calculated column to meet your requirement:

Year-Shown = [Year]

Year-Rank = RANKX('Table',[Year],,DESC,Dense)

Then we can make [Year-Shown] Sort by the [Year-Rank] column, and use [Year-Shown] column inside the matrix visual:

Best regards,

[amitchandak]

Make Rank as sort column.

Appreciate your Kudos.

[Greg_Deckler]

Have you tried a Sort By column?

[MS3]

Yes, I did this. So it sorts correctly, but my headers are still the Rank position as opossed to the Year itself (e.g. 2019)

[v-lid-msft]

Hi @MS3 ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[amitchandak]

 @MS3 , If possible please share a sample pbix file after removing sensitive information.Thanks.