ToolTip Advance - Filter Help

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