ToolTip Advance - Filter Help

[dvraan]

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:

1. 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 

[dvraan]

This solution is great. Thanks! @SamWiseOwl 

[SamWiseOwl · Accepted solution]

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])