Forum Discussion
Helper IISort by month in Power BI
Hi - I have a column chart sorted by month, but Jan and Feb 2021 are sorting before March 2020.
I have created a month number column in format yyyymm, but cannot add this to get the chart to sort in correct chornological order.
Many thanks for an explanation on how to fix this!
CJDK , You need the first column and the second one is a sort column for the first one
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
2 Replies
- amitchandak
Super User
CJDK , You need the first column and the second one is a sort column for the first one
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
CJDKThank you Amitchandak! Once I figured out to use the New column option it was exactly what I needed!