Bar Chart Sorting Order Month/Year (MM/YY)

[waqasshah]

Dear All,

I am developing a dashboard unfortunately I am unable to sort out the bars in a chart. I want them in chronological order. like Oct/16 , Nov /16, Dec 17. The values used for calculations are CompleteMonthNamesRefRcvd and CompleteYearNameRcvd. 

I have attached the screen shots please review them.

Kind Regards

Waqas Shah

[techvarun]

Share a sample to get faster responses

[Chanty4u]

try this

in sort tab...

Expression:

=Match(FieldName,' A','b','c')     lik so on 

or u wan load order  ascending or desc  chk that

[waqasshah]

I have attached screen shots..

[tresesco]

May be sort by expression:

=Date#(YourDateField, 'MMM/YY')

However, ideally this should be taken care in the script itself. You should create the field as a dual, like:

Dual(Left(....)&'/'&Right() , Date#(YourDateField, 'MMM/YY')) as YourDate

Once this is done in the script, the dates would be be automatically sorted in the UI.

[its_anandrjs]

Share some sample file make be your date is not in proper format like MMM/YY or MMM YY or MMM /YY

In Sort Tabe use

=Alt(

date#( CompleteMonthNamesRefRcvd &'/'& CompleteYearNameRcvd, 'MMM/YY'   ),

date#( CompleteMonthNamesRefRcvd &' /'& CompleteYearNameRcvd, 'MMM/ YY' ),

date#( CompleteMonthNamesRefRcvd &' '& CompleteYearNameRcvd, 'MMM YY' ) )

[Anil_Babu_Samineni]

What if you are getting when you un-select all options from SORT tab?

[waqasshah]

Thanks @tresesco

this function works

but I am trying to create the following in my dimension but it wont work..

=Dual(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(RIGHT(CompleteYearNamesRefRcvd,2)) , Date#(CompleteYearNamesRefRcvd, 'MMM/YY')) .  please help

[waqasshah]

it wont work

[waqasshah]

Thanks but it did not work