Forum Discussion
Helper INot able sort Month on X axis
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
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.
4 Replies
- amitchandak
Super User
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) 
Tony_KuiperHave 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.
heygauThank 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
v-yalanwu-msftCommunity Support
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.
