Forum Discussion

heygau's avatar
heygau
Icon for Helper I rankHelper 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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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)