Forum Discussion
Month Sort by short name error
Hi There! I have been tearing my sparse hair out re an error with sort orders for months. Went through the whole Date table setup, sorted by month number, report Matrix works with long month ...
TillerTechnical , If it month or month year you need a sort column
--Month Year
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")
Sort on Month Year sort
Month = FORMAT([Date],"mmm")
Month sort = FORMAT([Date],"mm")
Sort on Month sort
refer : https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Thanks Amitchandak,
I did do that, setting up a month sort column and followed normal processes as you suggested, though it has not worked.
