Conditional tooltips in PBI.

[na12063]

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!

[v-huijiey-msft]

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]

@v-huijiey-msft, 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,

[v-huijiey-msft]

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!

[lbendlin · Accepted solution]

Did you raise the idea?

[na12063]

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

Microsoft Idea

[lbendlin]

voted

[lbendlin]

You cannot not show them.  You can show a blank tooltip but that's a bad UX.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41