Forum Discussion
sorting months in order
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.
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.
this doesn't work as I already have a table with dates, so that table needs the order.
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.
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.Hi mkane12 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.
Thank you.