Forum Discussion

mkane12's avatar
mkane12
Helper I
1 year ago
Solved

sorting months in order

how can I sort my months in order?   
Need Help
  • v-tejrama's avatar
    v-tejrama
    1 year ago

    Hi mkane12 ,

     

    Thank you for your follow-up, and you’re correct to highlight that. If you’re already using a date table, such as a Calendar table with all dates included, there’s no need to create a separate Month table just for sorting. You can sort the month names directly in your existing date table.

    Make sure your table has a column for the month name (like "January", "February") and another for the month number (1 to 12).

     

    Thank you.

     

v-tejrama's avatar
v-tejrama
Community Support
1 year ago

Hi mkane12 ,

Thanks for reaching out to the Microsoft fabric community forum.

 

I encountered the same problem with the months displaying alphabetically instead of from January to December. To resolve it, I built a separate Month Table with two columns: MonthName (e.g., January, February) and MonthNum (1–12). I then used the "Sort by Column" feature on MonthName, sorting it by MonthNum.

 

Using this MonthName in the visual ensures the months now appear in the correct calendar order.

 

Please find the attached .pbix file for your reference.

 

Best Regards,
Tejaswi.

v-tejrama's avatar
v-tejrama
Community Support
1 year ago

Hi mkane12 ,

 

Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.

 

Thank you.