Grafana - color single stat when null value found (data source elasticsearch)

Hello,

I am trying to color (using thresholds) single stat box in Grafana 6.0.0 when NULL value is found using Elasticsearch datasource. Can you please let me know if this is possible (I have seen other similar posts but for other datasources).

I have the same issue in table panel as Elasticsearch datasource.
The threshold doesn’t work with a null value in JSON Data as a table transformation option.

Anyone can help us?