Forum Discussion

4rmfunction's avatar
4rmfunction
Frequent Visitor
2 years ago

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...
4rmfunction's avatar
4rmfunction
Frequent Visitor
2 years ago

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! 

lbendlin's avatar
lbendlin
Super User
2 years ago

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