Tooltip Page Filters & Visual Calcs

[music43]

Hi

I couldn't see it listed in the visual calculation limitations. I have a small column chart as a tooltip page and I have created a couple of visual calculations to count how many columns exceed the average.

When manually filtering the tooltip page it appears to work, but when viewed from the report page (as a tooltip) and the implicit filters are in place, the result is wrong.

Does anyone know, if this should work (in which case I need to look at my calculations) or is this a limitation of visual calcs?

Thanks all.

Oli

[rohit1991]

Hi @music43 

It’s a limitation of context. On a tooltip page, Power BI adds a hidden filter for the hovered category. Visual Calculations run after that filter, so “count above average” is computed on a tiny set and looks wrong.

Fixes (pick one):

• Use a DAX measure that ignores the hover category (e.g., average with ALLSELECTED or REMOVEFILTERS, then count values > avg).
• Keep visual calcs but turn off “Keep all filters” on the tooltip page and don’t pass Category in Tooltip fields, so the tooltip contains all columns to compare.

[pankajnamekar25 · Accepted solution]

Hello @music43 

This is a limitation of visual calculations in tooltip pages — they may not correctly re-evaluate with hover/implicit filters from the main report page. For precise logic (like comparing to dynamic averages), prefer using DAX measures over VCs in tooltips.

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.