Date (string) sorting

[Anonymous]

I struggle sorting dates and I'm not sure why. The below screenshot are my results but I would like the chart to read left to right.

I would like to see.

2/13/17      2/20/17    2/27/17

Can someone help and also help me understand why this occurs?  See attached for sample app.

[sunny_talwar · Accepted solution]

Try this expression with Ascending sorting

=If(NoOfRows() - RowNo() < 3, Count(id))

[annafuksa1]

Check my app and chart Anna Chart, its different approach