I have multiple energy meter kWh counters recorded from which i build via spread() hourly consumption values and I add them then via a transform to a total energy counter.
This works fine and the total kWh of all meters are shown correctly.
Then I tried to color all bars which are positive in green and all which are negative in red via threshold color, but for some reason it does not work.
It colors allways all in the same color, depending on the threshold value:
I tried to reproduce it using TestDB Data source while deploying Grafana v.8.4.1 on Docker but not able to reproduce it.
In my case I selected the CSV File from the TestDB Data source and while using Bar chart and it shows the green color as default (as based on the threshold value).
I will suggest that if you can reproduce it by creating a test env. where version 8.4.1 is running and after update to 9.1.7 then please share the step by step instructions (will also prefer to use Data source like a TestDB or a CSV file as easy to reproduce).
Then share it with us.
If you cannot able to reproduce the issue with TestDB and only happens in your selected Data source then share a detailed screencast.