Skip to main content
cancel
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.

Reply
4rmfunction
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:

4rmfunction_0-1708712992631.png4rmfunction_1-1708713057446.png


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 5
4rmfunction
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:

4rmfunction_2-1708739082296.png

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"

lbendlin
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 https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

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/1447...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors