Forum Discussion
Years descending order
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 🙂
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:
5 Replies
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!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
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:
