Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

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!

Regular Visitor

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"

Super User
Super User

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

Please show the expected outcome based on the sample data you provided.

Want faster answers?

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors