sorting by expression not working

[Tommmy]

Hi experts

Why does the sorted expression is not working correctly? April 2020 is at the beginning, should be between March and May. Any ideas?

Formula of the bars: RangeSum(Above(Sum({<[Status]={'Open'}>} [# Points]), 0, RowNo()))

The x axis is sorted by an expression: =month([Date]) & '-' & year([Date])

[brunobertels]

Hi 

Use dual function in your x axis dimension 

Dual give text expression and num expression 

somethink like 

dual( month([Date]) & '-' & year([Date]) , month([Date]) + year([Date])*100)

Hope it helps