Sort by month-year wise at x-axis not working

[goyalsa]

Hi All, 

I am trying to sort by "Month-Year" but not able to get the X-axis according to that.

i created a custom column "MonthYear = FORMAT('Master data (history)'[In date].[Date],"MMMM-YYYY")" . I can not figure it out where I am lacking in it.

Here is the screen shot of result :

Thanks in advance!!

[goyalsa]

Thanks @amitchandak . 

Have a great day!!

[goyalsa]

Hi @amitchandak ,

I think it works in that way but itn't possible to change month in albhabets instead of numeric and do the same.

Thanks for the quick response.

[amitchandak · Accepted solution]

@goyalsa , Your old column will only sort correctly. You just need give sort order using sort column. No need to use this new column

refer my video, if needed -  How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c

[amitchandak]

@goyalsa , Create a new column

Month Year sort = FORMAT([Date],"yyyymm")

and mark that as the sort column of this column