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 by month name. Please see below:
All of the visuals on this page are experiencing the same issue. Has anyone come across this and if so, were you able to fix it? Does anyone know what may be affecting the visuals in this way? Thanks so much!
5 Replies
Your calendar table must have a Month Number column in addition to the Month Name column. Then use "Sort a column by another column" to sort the month name by the month number.
Your display seems accurate. What would you expect instead?
Hi lbendlin,
I think it's the formatting in my rolling calendar that is affecting the visuals. When I change the date format in the formula bar to yyyy-MMM, it reverts to the date being ordered chronologically by month name instead of by date. When I have it as yyyy-MM, it sorts the visual by date.
Thanks for your insight!Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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"
