Not able sort Month on X axis

[heygau]

I am not able to sort axis based on monthName , Month names are as per finacial year somehow November nad decmeber sitting next to each other , is there any way to sort them out 

[v-yalanwu-msft · Accepted solution]

Hi, @heygau ;

I reproduced your issue as follows：

And you could sort by year and month.

Then the month column sort by "month-sort" column.

The final show:

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.

[heygau]

Thank you @Tony_Kuiper  @amitchandak 

Its not helping me, because the X-axis shows last 13 months, somewhat Novemeber Data(Current Year, Previous Year ) is sitting next to each other 

[Tony_Kuiper]

Have you checked if the sort option is available in the top right of the visual??

If not... I like to create a column 

DateSort = CONCATENATE(YEAR(Table1[your date]),MONTH(Table1[your date])) when these things dont play nicely.

You can then select the original date column you are having trouble with and do a "sort by" and use this numerical version... You can extend it out to the day if you need to by adding another concatenate nested inside that one.

[amitchandak]

@heygau , You month need have month sort column

for cal year

Month Year = FORMAT([Date],"mmm")
Month Year sort = month([DAte])

For FY assume FY is not same for all month , year start from NOV

Month Year = FORMAT([Date],"mmm")
Month Year sort = if( month([DAte])<11, month([DAte])+2, month([DAte])-10)