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!
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Did you raise the idea?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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
    2 years ago

    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,

     

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Did you raise the idea?

      • na12063's avatar
        na12063
        Resolver I
        2 years ago

        lbendlin , Yes, I did, thank you for asking. Here's the link below. Please take a moment to vote.

        Microsoft Idea

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi na12063 ,

       

      It is out of the question.

       

      Thanks for the idea via the URL lbendlin provided, it was very helpful.

       

      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!