Forum Discussion
Helper IVYears descending order
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:
Helper IVin 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
Community ChampionHi,
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: