How to hide tooltips if data is blank

[joce1127]

Hi,

1. If my data is blank/empty, the tooltips will no show the tooltips table or window. If I have data only pop out the tooltips table/ window. How to do or create DAX?

2. If I have 2 rows, one is called "Plan", another is called "Actual". How to tooltips data only pop out in "Actual" row?

[Anonymous]

Hi @joce1127 ,

DAX does not control the visibility of tooltips. This can be achieved by adjusting the filters on the visual or using a measure that returns null for blank values, as null values ​​do not display tooltips.

When I hover the mouse over Jan-3, no tool tip pops up.

To conditionally display tooltips for rows marked as "Actual" while hiding rows marked as "Planned", you can create a measure that does not display tooltips for null values.

Measure = IF(MAX('Table'[Type]) = "Actual",MAX('Table'[Value]),BLANK())

The pbix file is attached.

If you have any further questions, please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!