Sort order for legend not working
I'm trying to sort a legend on multiple charts by High > Medium > Low and I'm using the formula below, then sticking it in the sort field, but its not sorting by it. It looks to be sorting by the count of item in each of these categories. What am I doing wrong?
WHEN `EB Project Risk`='High' THEN 1
WHEN `EB Project Risk`='Medium' THEN 2
WHEN `EB Project Risk`='Low' THEN 3