Not sure if this is what your after but you can sort your data by an expression. Go to chart properties->Sort and check the Sort by expression checkbox. Then write whatever expression you like. It will be evaluated over the dimensions in your chart and the chart will be sorted by the expression result.
