Forum Discussion

na12063's avatar
na12063
Resolver I
2 years ago
Solved

Conditional tooltips in PBI.

Has anyone encountered a similar scenario where you needed to not display tooltips if a specific record is blank?

If yes, kindly share details on the solution in the comments.

Thank you!

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi na12063 ,

     

    lbendlin makes a good point.

     

    You can not apply tooltips to some records and not to some, either both or neither.

     

    The alternative is:

     

    You can create a measure that performs this action, and then place the measure in a customized tooltips page before applying it to the visual object; if you place it directly in the "tooltips" section of the visual object, it will not display correctly.

     

    The measure syntax is as follows:

     

    measure = IF(ISBLANK([Value]), BLANK(), [Value]&"")

     

     

    If you put the measure directly into the "tooltips" section of the visual object, it will be displayed as follows:

     

    Putting the measure into the customized tooltips page and then applying them to the visual object results in the following display:

     

    For information on creating custom tooltips and applying them to tooltips, see the following documentation:

    Create report tooltip pages in Power BI - Power BI | Microsoft Learn

    Customizing tooltips in Power BI Desktop - Power BI | Microsoft Learn

     

    The pbix file is attached.

     

    If you have any other go 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!

    • na12063's avatar
      na12063
      Resolver I

      Anonymous, thank you for your response. In this case the tooltips still gets displayed and I was wondering if it's possible not to display at all for blank record.

       

      Regards,