Forum Discussion
Tooltip Page Filters & Visual Calcs
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
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
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
2 Replies
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
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
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.
