Tooltip should not appear on total line

[PaulCz]

Hi,

we have created a tooltip as a quickinfo.

But the tooltip should not appear on the total line.

How can i fix this?

Thanks,

Paul

[anilelmastasi]

Hey @PaulCz ,

Could you please create this measure and add as tooltip?

TooltipMeasure =
IF(
HASONEVALUE(YourTable[YourColumn]),
YourTable[YourTooltipColumn],
BLANK()
)

[PaulCz]

Hi,

does not work.

No individual value can be determined for the “Project” column in the “BD_Schedule_Report” table. This can happen when a measurement formula references a column with many values ​​without specifying an aggregation such as MIN, MAX, COUNT, or SUM to get a single result.

[anilelmastasi · Accepted solution]

Let's try another measures:

TooltipMeasure =
IF(
    NOT(ISBLANK(SELECTEDVALUE(BD_Schedule_Report[Project]))),
    SELECTEDVALUE(BD_Schedule_Report[YourTooltipColumn]),
    BLANK()
)

Or

TooltipMeasure =
IF(
    HASONEVALUE(BD_Schedule_Report[Project]),
    MAX(BD_Schedule_Report[YourTooltipColumn]),
    BLANK()
)

[PaulCz]

wow..the first one has worked out. Thank you so much.

[suparnababu8]

Hello @PaulCz 

I also had the same requirment. I tried but didn't get result as expected. We can't restrict the tooltip for certian part of visual. Hence, finally I would say it's impossible to turn off tooltip on total line.

Thanks!