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

[tresesco]

Try like:

Dual(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(RIGHT(CompleteYearNamesRefRcvd,2)) ,

          Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(RIGHT(CompleteYearNamesRefRcvd,2)), 'MMM/YY'))

[Chanty4u]

Have a look here   it  may help

Sort date in Month Year format

Sort order with year-month

[its_anandrjs]

Try with this

Load

Date(Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&RIGHT(CompleteYearNamesRefRcvd,2),'MMM/YY')'MMM/YY') as FielName

From Source;

In sort use

=Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(CompleteYearNamesRefRcvd,2),'MMM/YY')