Forum Discussion

andregrgr's avatar
andregrgr
New Member
2 years ago
Solved

Power BI Matrix Date Column Sorting

I have a table working for me. Where I have one category in my rows and month-year in my columns. I want to be able to sort my columns by date, soonest to latest but They are sorting alphabetically, ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Ritaf1983 ,

Thanks for your approach.

What if I need to sort the months in descending order?

Like Jan 2024, Dec 2023, Nov 2023 and so on.

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 
Then you need a calculated column with this logic to sort by :
sort_month_yar = -(financials[Year]*10000+financials[Month Number])
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Perfect, worked smoothly!!
    Many thanks

    • Ritaf1983's avatar
      Ritaf1983
      Icon for Super User rankSuper User
      2 years ago

      Happy to help 🙂

      please consider Accepting  the solution to help the other members find it more quickly

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Ritaf1983 In the same visual I need to show months as well (from another date column) on the rows of the matrix, like below-

        How can I sort the rows in the same way?

  • Mohanad-Mustafa's avatar
    Mohanad-Mustafa
    Icon for Advocate III rankAdvocate III
    2 years ago

    Hi Ritaf1983 , really need your kind assistance, I did what you said my dates are still showing the old year like 2023 and then the new year like 2024 on my Matrix visual, any suggestion as why is that? I have followed all the steps you mentioned by adding the - sign before the measure 

    • Ritaf1983's avatar
      Ritaf1983
      Icon for Super User rankSuper User
      2 years ago

      Hi Mohanad-Mustafa  if it isn't working, something is not as I explained.
      Please share the link to the pbix and I will try to help.