# How to disable tooltip for 0 valued bars in perspective xy chart

**URL:** <https://forum.inductiveautomation.com/t/how-to-disable-tooltip-for-0-valued-bars-in-perspective-xy-chart/82550>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [November 30, 2023, 6:43pm UTC](https://forum.inductiveautomation.com/t/how-to-disable-tooltip-for-0-valued-bars-in-perspective-xy-chart/82550 "2023-11-30T18:43:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Radiophonique](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/radiophonique/32/55092_2.png) [@Radiophonique](https://forum.inductiveautomation.com/u/Radiophonique)\
**Post date:** [November 30, 2023, 6:43pm UTC](https://forum.inductiveautomation.com/t/how-to-disable-tooltip-for-0-valued-bars-in-perspective-xy-chart/82550/1 "2023-11-30T18:43:44Z")

</div>

I have a XY chart with multiple stacked series, which each have a tooltip.  
My problem is that 0-valued bars still seem to create a tooltip if the mouse hovers over the right area, including on top of another valid bar.

This could create confusion if the wrong tooltip pops up over a valid bar.

How can I change this behavior?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/5/a5f81df17f7915c5692b5298045f81a4d146af70.png)

---

<div class="post-metadata">

**Author:** ![Radiophonique](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/radiophonique/32/55092_2.png) [@Radiophonique](https://forum.inductiveautomation.com/u/Radiophonique)\
**Post date:** [November 30, 2023, 7:38pm UTC](https://forum.inductiveautomation.com/t/how-to-disable-tooltip-for-0-valued-bars-in-perspective-xy-chart/82550/2 "2023-11-30T19:38:45Z")

</div>

Workaround update:

I modified my SQL query and added NULLIF(..., 0) around every field affected to return NULL instead of 0 as a workaround, since "null" values don't create a tooltip.

Is there a better supported way?