How to set up correct sorting in bar chart

[#1]

Hi all, I have a problem when creating a bar chart. I have a dimention - date  and measure - some expression.

But I can't make this chart showing all dates in order

I have a master calendar in my load script.

Can you please help me with that?

Sorting options in chart properties are not giving anything

Thank you!

[#2]

I'm using Date_Main as dimension and simple expression like sum(sales)/count(transactions) as Measure

[jagan]

Hi,

Is both date fields in your Transaction & Calendar table are in same format?  Check it.

Regards,

Jagan.