How to sort a date-type slicer in descending order?

[Anonymous]

I have a column for Cal Year.

2014

2015

2016

2017

2018

My users want to see this data in a Matrix View sorted in Descending Order.

I have created an indexed column, and tried to sort via this.

Study Year Desc Sort = RANKX(ALL('Year Descending'[Study Year Desc]),'Year Descending'[Study Year Desc])

However, when I try and add this to my table and sort by it (so I can have the greatest year on the far left of the matrix). 

I get this error.

There has to be a way right?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

According to your requirement, I am willing to recommend you several solutions, please take it at your convenient.

One solution is that you need to add an custom column in query editor as follows, then change the data type of each column to whole number.

Then you could sort your matrix column using this index column.

Select the matrix visual and the ‘year’ in FIELDs pane, then select Modeling>Sort by Column>Custom, finally, you will get the following result.

Another is to add a conditional column in query editor, then edit it as follows. Next step is similar to the previous one.

If you have any question, please feel free to ask.

Best regards,
Yuliana Gu

[Anonymous]

Thank you, I was missing that data type step to change it to a whole number!!!