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, my advise would be,
create your date table with Power Query Guru Melissa De Korte's ultimate date function in Power Query. https://forum.enterprisedna.co/t/melissa-date-table-replacing-fiscal-to-financial-year/58870/4
Keep the Month number or Year number as part of your date table (or you can add any other necessary columns later). This would save you a lot of time writing/having AI generate DAX later.
After date table loaded into Power BI, build one to many relationship with your fact table so that this Data table can filter your fact table.
Sort by Month number under Data view, or if in other types of visuals you can sort them in tooltips as well.