Hello,
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?
Thanks,