Forum Discussion

joce1127's avatar
joce1127
Frequent Visitor
2 years ago

How to hide tooltips if data is blank

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?

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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!