topic Re: Years descending order in DAX Commands and Tips

Years descending order

giuliapiazza94 — Wed, 15 Dec 2021 12:41:57 GMT

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 🙂

Re: Years descending order

ValtteriN — Wed, 15 Dec 2021 12:47:15 GMT

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!

Re: Years descending order

giuliapiazza94 — Wed, 15 Dec 2021 12:53:27 GMT

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

Re: Years descending order

ValtteriN — Wed, 15 Dec 2021 13:10:12 GMT

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:

Re: Years descending order

giuliapiazza94 — Wed, 15 Dec 2021 13:34:08 GMT

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

Re: Years descending order

ValtteriN — Wed, 15 Dec 2021 13:58:40 GMT

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