MonthnYear Not sorting as expected from the video instructions

[ScottTPA]

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: 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?

[BrianJ]

@ScottTPA,

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

• Brian

[ScottTPA]

Excellent. That worked! Thank you.