Changing date sort with Data using DD/MM in SaaS

[shaunawilson]

My date ranges for my app are ranged from DD/MM-DD/MM (eg. 01/12-20/11) and when I'm building my bar chart, I can't seem to get it to recognize that it shouldn't be sorted by the DD first, but rather the MM first.

[Digvijay_Singh]

Looks like your chart dimension is a text field, not sure but somehow you would need to use the actual date field if you want to sort by different order. I would try dual(current text dimension, relevant date field) function to somehow get the capability to sort by date field but show the required text value in the chart.