Forum Discussion
Visuals not sorting months chronologically by year
Hi all, I am having an issue with my visuals displaying the slicer filters correctly. Instead of the months being displayed in chronological order, they are being displayed in chronological order...
Thanks lbendlin,
Unfortunately, it looks like a formatting issue. Your solution gave me the same result as my original message.
When I use a custom column with the input =Date.ToText([Date], "yyyy-MM"), I wind up with the visuals looking like this:
Which is great because they're in chronological order. I was hoping to format the code so it would give me a JAN or FEB, but when I do, it also reverts back to the original issue. If you have any other insight that'd be great though.
You have to include the year to make it work. Don't use any hierarchies, instead use the date and format it as "mmm yyyy"