Sort by month number isnt sorting the months

[Anonymous]

Hi,

I have a calculated date table with month number being generated by

Month = month('Calendar'[Date])

The month name is generated by

Month Name = FORMAT('Calendar'[Date], "MMM")

The issue is if I even use the srt by column for month name to be month it does not put them in the correct order...

Any help appreciated.

[Anonymous]

Hi @rodrigosan @amitchandak 

I have tried sorting on the visual and still experiencing this issue

 It is a DAX calculated table and sort by column is set to month

Thanks

[rodrigosan]

Hello, was your date table created in DAX or Power Query?

[amitchandak · Accepted solution]

@Anonymous ,it should do in a visual, if you sort on the month name column. Make sure sort column is correctly marked

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[Anonymous]

That resolved the issue.. thanks