Hide Null Value Gauges

Grafana Gauge Panel
1

  • 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:

    image
    image1088×316 25.9 KB

  • 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:

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

2

Hi @danieltown22,

Thank you for posting your question.

We see that by default if there is a value as “0” then it will appear in the panel as shown in the screenshot (not doing any override, transform, etc.)

image
image1494×646 64.3 KB

However, If we set the value as null in the editor, then it is no longer displayed in the panel:

image
image1907×635 73.8 KB

So what you can do is define NULL value as the default data type in the table and when there are no values that appear after running the query, It will be filled with NULL also on the Grafana side and might workout for you.