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.)
However, If we set the value as null in the editor, then it is no longer displayed in the panel:
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.