I have a date slicer for many reports. This is taken from the date calendar. Something that we have run in to is when year ends is that the dates are all out of order in the slicers. Ideally, we would want the three letter abbreviation for the month "mmm". This works until you pass 2018 and the sorting is not right. It seems like a lot of maintenance doing the date slicers in this way. I have changed the dates to yearmonth so that they are in order, however, this doesn't look great on the page. Seeing "Jan" would be better than 2018/01. Is there anyway to sort by yearmonth but display the month name only? I want this to be maintenance free and don't see a way of doing it without using yearmonth formatting. Here are screenshots below of the behavior. One has Jan on the left when it should be on the right (sorted according to monthnumber it is 1 so it is first). The 2nd screenshot is in the correct order, but it's just a pain to look at for users.

If you can make do with it displaying Nov 17, Dec 17, Jan 18 etc, then make a column similar to how you've made your month name column except pulling in the year as well, and then sort this new column by your yearmonth column. I'm guessing the error when trying my first reply is that it doesn't know which year to map just a month name to

Date Slicer General Question | Microsoft Fabric Community

Forum Discussion

Related content

Generic Data Capability Question

Bookmark questions

Architecture question and brainstorming

Duplicate Slicer Question

Question About Slicer Search