arrange date in bar chart

[#1]

Hi, how do I arrange the dates properly in bar chart? My current bar chart is as such:

Thanks

[SunilChauhan]

right(Fieldname,4)&num(left(field,3)) in sort expression

else if you have datefield  then write down in sort express

hope this helps

[tresB]

Create the date field using MonthName() in the script, it will get sorted properly in the front end as expected.

Load

          MonthName(DateField) as [Month Name]

[ashfaq_haseeb]

HI,

I would suggest you to create a new field in your data-model like

MonthName(Date_Field) as MonthName

Then use this field in your chart as dimension, this will be properly sorted.

OR

use below

=Year * 100 + Month

By this you will always have numbers that are 6 digits

ex. 201401, 201402,201303,..... and so on

OR

try with sort by this expression (in sort tab)

=Year & num(Month, '00')

Regards

ASHFAQ

[#5]

Hi

Try like this

in edit calculated dimension write

monthname(date)

Bar chart-->Properties-->Sort Tab-->Select the dimension name--> then select order as orginal

Regards

Nirmal