I have a solution that works for your scenario but it might require you to restructure your data. This is how I got it working:
This table view shows how I supply my data to Grafana
And then just apply the “group by” and “rows to fields” transformations in order. This should allow you to control the colors from the database!
Unrelated: if someone could tell me how to do this trick for a timeseries, that would be amazing 