Forum Discussion

giuliapiazza94's avatar
giuliapiazza94
Icon for Helper IV rankHelper IV
4 years ago
Solved

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 🙂  
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    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:

     

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
    giuliapiazza94
    Icon for Helper IV rankHelper IV
    4 years ago

    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's avatar
      ValtteriN
      Icon for Community Champion rankCommunity Champion
      4 years ago

      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's avatar
        giuliapiazza94
        Icon for Helper IV rankHelper IV
        4 years ago

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