Years descending order

[giuliapiazza94]

Hi guys,

i have this matrix

and I'd like to have descending order of years without using a dax formula.

Is it possible?

Thank you all 🙂

[ValtteriN]

Hi,

You can select sort descending in option in the matrix:

If  you don't see this option check the data type of your year and how it is sorted. I hope this helps to solve your issue and if it does consider accepting this as a solution!

[giuliapiazza94]

in my report I see this 

i can order item (articolo) or sales (importo - fatturato),

not years. Why?😢

my column of years is a number type

[ValtteriN · Accepted solution]

Hi,

I forgot that matrix doesn't allow to sort by columns if you have row data. In this case it would be hard to sort the years in descending order without dax. You can change the row and column hierarcies like in this example and then sort the data. Otherwise I don't see a way to do this without dax or modifications to your data model:

[giuliapiazza94]

If I wanted to create a new table calendar that has descending order, which dax formula can I use?

[ValtteriN]

You can create negative year column and sort year column by it: