The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi @music43 ,
You're correct in observing unexpected behavior when using visual calculations (VCs) within a tooltip page — this is indeed a known limitation. While visual calculations can work as expected under manual filtering within the tooltip page itself, they often fail to correctly respond to the implicit filters passed through when the tooltip is triggered from the main report. This is because visual calculations are evaluated in the context of the visible data on the visual rather than recalculating dynamically based on the full filter context that tooltips inherit. For scenarios where you're comparing values to dynamic elements like averages, it's more reliable to implement this logic using standard DAX measures instead of VCs. This ensures the correct evaluation of filters and consistent results when tooltips are activated from different report visuals.
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.
User | Count |
---|---|
75 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |