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
When 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