Issue with Sorting Month-Year Order in the format of MMM-YY in the visuals

[Anonymous]

Hi PowerBians ,

I have developed a visual with MMM-YY month order and applied rolling 6 months logic .

But when it shows in visual looks weird that the sorting order not good as below :

Here after Dec-22 , Jan-23 should come but the 2023 months orders are coming reverse .

When i sort by month again then the visual starts with Jan-23 until May-23 and then Dec-22 displaying like below..

What should i do now to fix this ? Please help ..

BR

DK

[Anonymous]

Hi @Anonymous ,

You have to create column using DAX: 

Month-Year sort = FORMAT(Orders[Order Date],"YYYYMM")

and then sort by the Month-Year column by above created column

You can refer below link:

https://www.youtube.com/watch?v=KUcLScKYg9I 

Mark my post as a solution, if this helps you  

Thanks

[mlsx4]

Hi @Anonymous 

There is a nice video explaining it: https://www.youtube.com/watch?v=yx-Duj_KPtw

[TomMartens]

Hey @Anonymous ,

you need to create an index column sorting your  MM-Year values. This is explained in this article: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-desktop

For example YEAR*100+MonthNumber

Hopefully, this helps to tackle your challenge.

Regards,

Tom

[Anonymous]

@TomMartens @Anonymous @mlsx4  Thanks for your response ..

I already have a index column created in the table but still the order is missing ..

from dashboard 2023 data is sorting fine :

But 2022 year data is not .. how is it possible ? I tried to did sort axis options from the visual but still not sorting ..

[mlsx4]

Hi @Anonymous 

Your index column does not take into account the year, therefore it won't work. You should do some trick to the index column (as in the video or as Tom's solution) to consider the year too.