Forum Discussion
Messy month
Good community, I have a doubt with the temporal order in which the months are shown in a graph. May to August are shown well, but September derrepente is not shown in temporal order. The excel from which power Bi reads has the same cell format for every month... The display is temporarily ordered, but as you can see, September is not placed correctly.
Thanks in advance
Syndicate_Admin , Have created a sort month column and used that as sort column
Month Year = FORMAT([Date],"mmm")
Month Year sort = month([DAte])How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
3 Replies
I suspect the month is sort descending by alphabetically. Please check your month format is in date/datetime format
Syndicate_Admin , Have created a sort month column and used that as sort column
Month Year = FORMAT([Date],"mmm")
Month Year sort = month([DAte])How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-cHi, Syndicate_Admin ;
As amitchandak said, after using another column of sorts, change the sort order of the chart.
Sort by Month name.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
