how to sort month by order?

[#1]

hi to all,

Anyone of you explain how to sort the month by order.

My month dimension like below

month:

Apr

Aug

Jul

Jun

Sep

Oct

Nov

Mar

May

Jan

Feb

But I want month list like

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Nov

Dec

[#2]

Thanks works

[#3]

Hi Mohammed

I did that but is there a reason why if i select months the order jumps around.  how do i keep the order as jan to Dec irrespective of the month selected

[mohammadkhatimi]

In which chart you are applying???

[kavita25]

Try this Expression:

wildmatch(only({1}Month_field),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

only({1})- with this it wont change the order.

[sasikanth]

HI,

Uncheck State Check box , if you want to keep selected values as it is,

[#7]

Brilliant Thank you

[#8]

Thanks its working

[#9]

Excellent!! It worked flawlessly!!

It´s good to say that you must put that expression in the Sort tab of Properties.

[chandu441]

Thanks for your expression which helps for my case. After 3 hours of time waste I came to your suggestion.

[Anonymous]

It worked very well for me, but I couldn't understand why Month(MonthAbbr) do not work and Month(Date#(MonthAbbr, 'MMM')) works.

MonthAbbr being the abbreviation for the months names.