MonthnYear Not sorting as expected from the video instructions

In Sam’s video “Dynamically Compare Monthly Information Cumulatively…” he drops the MonthnYear function into a slicer and it sorts properly by month-year. I am using the date table from the lessons and I get this: powerbi%20forum1 I think I am doing what is suggested to correct this and sorting the table by a different column that sorts correctly. See the image below:

Is there something else I need to do to sort my slicer by MonthnYear?


If you sort MonthInCalendar by MonthInYear, it will correct the order in your slicer per the screenshot below:

  • Brian

Excellent. That worked! Thank you.