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:
If you sort MonthInCalendar by MonthInYear, it will correct the order in your slicer per the screenshot below:
Excellent. That worked! Thank you.