Forum Discussion

heygau's avatar
heygau
Helper I
3 years ago
Solved

Not 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 
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    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.

Tony_Kuiper's avatar
Tony_Kuiper
Helper I
3 years ago

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.