Forum Discussion
Change month order on vizualization
Hello.
How can I change month order in my vizualization?
I need it to start from November, not January
You need to add a Sort By column that has November as 1, December as 2, etc. You can add a calculated column that calculates against your Date column like this, and then use the new column as the sort for your Month column.
MonthSort = var thismonth = MONTH('Date'[Date])return IF(thismonth<11, thismonth + 2, thismonth - 10)However, this may not be what you want, as it will put Nov first within a given year (Nov 2020, Dec 2020, Jan 2020, etc.). You can see this article that show how to make no-sort Date tables that you may be able to adapt for your need.Pat
1 Reply
- mahoneypat
Microsoft Employee
You need to add a Sort By column that has November as 1, December as 2, etc. You can add a calculated column that calculates against your Date column like this, and then use the new column as the sort for your Month column.
MonthSort = var thismonth = MONTH('Date'[Date])return IF(thismonth<11, thismonth + 2, thismonth - 10)However, this may not be what you want, as it will put Nov first within a given year (Nov 2020, Dec 2020, Jan 2020, etc.). You can see this article that show how to make no-sort Date tables that you may be able to adapt for your need.Pat