Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hello Everyone,
I'm trying to create a dashboard, where most of the Metrics are shown with Cards and some with column charts.
There is a custom Tooltip created for these visuals, showing more details about the respective metric, such as definition, target, etc.
In the Card, I'd like to also show also the historical trend for the metric, while still being able to filter (with slicers) the other parts of the Tooltip per country and month.
I've been doing that by swithing off the Keep all filters option in the tooltip and adding only the Metric names in the Tooltip fields. This is working fine for visuals like the column charts, so no issues there. However, the information is not displayd correctly for the Cards. Either all filters are applied and the trend is not shown, or all data is displayed at the same time, regardless of the country/month filters, which is unusable. The Card seem to ignore the the Metric names data added in the "Drag tooltip fields here" in the Tooltip. Is this a bug, which can be fixed, or can anyone recommend a workaround?
Thanks!
HI @LLine,
Can you please share some more detail about these? (the tooltip page design, filter fields settings) They should help us clarify your scenario and test to troubleshoot.
How to Get Your Question Answered Quickly
In addition, if you want to achieve a customized filter effect, you can try to use an unconnected table as the source and write a measure formula to apply the filter effect on the 'visual filter level'.
Applying a measure filter in Power BI - SQLBI
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
Thank you for your response!
I managed to find sort of a workaround by creating a measure of the data with CALCULATE(ALL)), in order to force the visual to ignore the slicers, even if the Keep All Filters setting on the Tooltip is on.
However, I still think there are some weird issues with the connection between Cards and Tooltips. For example, the applied method above works only if the Date is set to Hierarchy. Otherwise, the tooltip again shows only one month, so it's not possible to use the Relative Date Filter, in order to display only the last 12 months.
Thanks for your help.
Regards