Sort Order not working

Hi All

I've followed the exact same patterns, methods and relationships as previous but for some reason my visual won't sort the values by the order I've chosen in the index table

Summary

table with data has field call SENTIMENT (Positive, Negative, Mixed, Neutral)

index table has 4 different sentiments, with conditional column (1-4 respective ordering) and has been sorted by ascending

When I add the visual to my legend the order is still mixed up

Again, this is exactly what I've done for about 9 or 10 other reports but this one is just being a pain

Any ideas?

Thanks

Dan