topic Visuals not sorting months chronologically by year in Custom Visuals Development Discussion

Visuals not sorting months chronologically by year

4rmfunction — Fri, 23 Feb 2024 18:32:22 GMT

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!

Re: Visuals not sorting months chronologically by year

lbendlin — Sat, 24 Feb 2024 01:27:00 GMT

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?

Re: Visuals not sorting months chronologically by year

4rmfunction — Sat, 24 Feb 2024 01:46:32 GMT

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.

Re: Visuals not sorting months chronologically by year

lbendlin — Sat, 24 Feb 2024 02:20:52 GMT

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"

Re: Visuals not sorting months chronologically by year

4rmfunction — Thu, 29 Feb 2024 16:45:48 GMT

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!

Re: Visuals not sorting months chronologically by year

lbendlin — Thu, 29 Feb 2024 16:53:44 GMT

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