Change Bar Colors in a Grafana Bar Gauge Dynamically Based on a Field (No Manual Overrides)

I had a similar problem, I think I solved it here: Dynamic coloring for barchart bars by text value