Hide Null Value Gauges

  • What Grafana version and what operating system are you using?
    10.0.1

  • What are you trying to achieve?
    I am using the Gauge visual and I sometimes have many blank gauges, where their value is Null.

  • How are you trying to achieve it?
    I have tried using an override:
    image

  • What happened?
    Nothing

  • What did you expect to happen?
    I was hoping the null value gauges would disappear:

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No errors

  • Did you follow any online instructions? If so, what is the URL?
    Closest I could find is this:

https://localhost:3000/t/gauge-panel-do-not-display-gauge-if-null-empty-value/50793/2

But they actually wanted to achieve the opposite of what I want.

Our data source is an sql query. I’m pretty sure there used to be an option to hide null values in previous grafana versions (I can’t remember this being an issue until recent upgrades) I may be wrong though! Any help offered will be gratefully received.

Dan