ToolTip Advance - Filter Help

dvraan — Thu, 01 May 2025 00:00:32 GMT

Hi all,

I'm working on a Power BI report where I show monthly Gross Sales in a table and would like to display a tooltip chart when hovering over the table rows. The goal of this tooltip is to show the entire year's trend line for Gross Sales, not just the single month that was hovered.

What I want:

When hovering over a row (e.g., Brand 3), I want the tooltip to show a Bar chart for the full year (e.g., Jan–Dec ).
The tooltip should still respect other slicers from the main page:
e.g., State but ignore Month Slicer

What I’ve Tried:

Created a Tooltip Page.
Enabled the page as a tooltip and linked it to the table.
It works — but only shows a single month (the row context from the table).
However, the date context from the hovered row still dominates the chart axis — only one Bar appears instead of the full year.

What I Need Help With:

How can I structure my tooltip chart (and DAX) to:
1. Ignore just the row-level month/date from the hovered row
2. Still respect the full context of slicers (State etc.)
3. Always show the full year trend on the tooltip chart?

File working

Re: ToolTip Advance - Filter Help

SamWiseOwl — Thu, 01 May 2025 09:08:19 GMT

Hi dvraan

You would need to create a seperate table with the Month Name in it and use that in a slicer.

This would not filter the model.

Instead we edit the Gross column to say:

Gross = CALCULATE( SUM(Sales[Gross Sales]), 'Date'[Month] = SELECTEDVALUE('Month Table'[Month name]))

Then in the tooltip chart just put the:
SUM(Sales[Gross Sales])

Re: ToolTip Advance - Filter Help

dvraan — Thu, 01 May 2025 13:07:02 GMT

This solution is great. Thanks! SamWiseOwl

topic Re: ToolTip Advance - Filter Help in DAX Commands and Tips

ToolTip Advance - Filter Help

What I want:

What I’ve Tried:

What I Need Help With:

Re: ToolTip Advance - Filter Help

Re: ToolTip Advance - Filter Help