How can I change the threshold colors from config query?

[danielgnebackup]

Hi, I have an MSSQL query to load dynamically the threshold values, that is because I have a variable in the dashboard that changes the variable displayed, so I need to change the threshold depending on the variable, right now I can load the threshold values using the transformation type “Config from query results” but I can not assign the colors, I have tried with columns with the color names but nothing happened, so I want to know if someone has an idea about how to manipulate the threshold colors using the transformation “Config from query results”.

Right now I am getting each threshold value in a column, it works, but the colors are the problem, all of them are red and I want to assign a different color for the different thresholds.

Just in case, I am using grafana version 8.1.2.0.
Thanks in advance for any help you can give me with this.

[mattabrams]

Hi @danielgnebackup

thanks for bringing this up. Fiddled with some examples for a few minutes but I’m blocked. This might need to get reported in the repo as a bug / enhancement

[xflopin]

Hi,
I’m trying to solve a similar problem, have you found any solution or has there been any development since?
Thanks

[brentcoosemans]

are there any updates on this problem?

[alex389]

Hello!

I’m really interested in this topic too but i cannot make it work with 8.2.2. Do we have any updates on this?

Thank you very much

[matzeeg3]

@alex389

I’m really interested in this topic too but i cannot make it work with 8.2.2. Do we h

Same here. Any news?

[pracingindCTX]

I have the same issue, my current version is 8.4.3. Any news about changing the threshold colours?

Desired outcome:

[yosiasz]

[brentcoosemans]

this only works when you configure the value mapping beforehand, there is no way to dynamically set the threshold.