Forum Discussion
Sort Date table by column
i am trying to sort my short month col in chronilogical order. when i sort by year month interger i am getting this?
date table was created in dax, i just want to be able to display my months in order e.g Nov 2022, Dec 2022, Jan 2023, Feb 2023.
i think i used somehting before where i would sort by a unique interger but i not sure how i done this!
From what I understand you can use your "MonthYear" column sorted by your "YearMonthInt" column.
The month year charting is fine, i just want to display the month in short text but this happens