sort by month and year

[kasife]

Guys, I have a Matrix where my columns always have the 3 selected months and I would like to place them in order of month and year. As you can see, the ordering should be: November (2023), December (2023) and January (2024) but I'm not able to order it that way. How could I do this?

[Ahmedx]

you can implement this in power bi, but how will the user understand that this is January 2022 or 2023 and so on

[Ritaf1983 · Accepted solution]

Hi @kasife 
You can't sort months without years in chronological order.
There is no way for the engine to know when January is from last year and when from the next.
You should use some combination of year and month to make it work.

For example :

Which can be sorted by column with the logic:
Date.ToText([Date],"yyyyMM") from PQ 

Pbix with my example and calendar table with the needed columns is attached.

More information about sorting by month and year is here :
https://www.youtube.com/watch?v=kHK6bnaD8ig

[kasife]

@Ritaf1983 Thank you so much

[Ritaf1983]

Happy to help 🙂