Forum Discussion
Date Slicer General Question
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
Have you tried going into the modelling tab of data view and telling your column with Jan, Feb etc to sort by your yearmonth column?
Yes, I got this message when trying to do just that. *Monthshort is "mmm" or Jan, Feb, etc...
Hi joshcomputer1,
If you use the "mmm" month format, it will order the items using initial letter of the month. We can't order by YearMonthNum column because there are more than one value in 'YearMonthNum'. I personally suggest you use number month(1,2,3,,,,12) rather than mmm format. Please review this feature request and vote it.
Best Regards,
AngeliaWhen I use monthnum then when it flips to a new year, the slicer is out of order. For instance, it should read as this 8,9,10,11,12,1 but instead it reads 1,8,9,10,11,12. We have many visuals that are 6month or 12 month windows so going from year to year is critical for displaying correctly.
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
