Stacked Bar Chart: How to Turn Off Sorting on Hover Display?


I have a stacked bar chart and I managed to get everything sorted the way I wanted with CASE statements similarly to what is described here: SQL trick: ordering bars in a chart

However, when you hover, it does not respect the sorting. Instead, they are resorted based on value. See here:

Ideally, the hover would still display values in the same order as the legend. Not resorted by value.
Is there any way to adjust this behavior?