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 months are part of a date field, I do not have a column with just Months
Hi,
You should create a Calendar table with calculated column formulas for Month name, Month order and Year. Sort the Month name by the Month number. Create a relationship (Many to One and Single) from the Date column of your Fact table to the Date column of your Calendar table. To your visual, drag Month name from the Calendar table. Create a ytear slicer from the Calendar table and select a year.