Problem with sorting month names in calender table

Hello all,

sorry for not responding earlier. I still have the same problem. You can find an example file under the following link:

Power BI Example (Sort by month) 

In this exampe I would like to sort the table by the field "MonthYearNum" in the Calendar table but only show the name of the month in the table. In this case the sort order of the months should look like:

Okt

Nov

Dez

Jan

Feb

Mar

Apr

Mai

When you select the "Month" column in calendar table and then try to sort it by another column (in my case "MonthYearNum" this is not possible and an error message is shown. When I only have one year in the calender table (e.g. 2024) then this is working. 

So the only solution I have at the moment is to limit the content in calendar table to one year, then define the sorting of cloumn "month" by column "monthyearnum" and then fill the calendar table again with all needed data. this is wokring then, but that could not be the correct way to do that. There must be another way how to handle this.

Frank