Tooltip page that ignores month selection from graph

[atowriss99]

Hi,

I have a graph that shows curent yearly only for volume by product.  I have created a tooltip page that breaksdown each product by sub-type, aslo or Current Year only.  So, as of now, my line charts shows Jan-May, as does my tooltip line graph.
What I would like is when the user hovers over a month on the report graph, it shows all the months in the current year for each sub-type from the tooltip graph.  Currently, it just shows the current month the user is hovering over.
I don't want to ignore all flters, because I sill want to see the by product breakdown (which is a slicer and I can sync that one), but I have tables that show Top10 customers on the page as well.  I'd like the tooltip to be responsive to the customer (which is not a slicer), but show all the months in the current year selected.
I attempted to modify my current year measure to ignore the month portion of the selection, as below.  I tried removing both the Date and Disconnect Date month, but both still only show the current month selection from the original graph in the tooltip.
Can what I am looking for be done?
TIA

Measure to ignore month:

CY Only RP3 Volume(Ignore month) =

VAR _nbmonths=-month(max('Date'[Date]))

VAR _refdate=max('Date'[Date])

Var _predates=DATESINPERIOD('Disconnect Date'[Date],_refdate,_nbmonths,MONTH)

Var _result=calculate([Volume Counts],

REMOVEFILTERS('Date'),

KEEPFILTERS(_predates),

REMOVEFILTERS('Disconnect Date'[End of Month].[Month]),

USERELATIONSHIP('Date'[Date],'Disconnect Date'[Date]))

Return _result

[Jaywant]

To achieve the desired behavior where the tooltip in your line chart shows all the months in the current year for each sub-type, you can modify your measure as follows:

CY Only RP3 Volume (Ignore month) =
VAR _currentYear = YEAR(MAX('Date'[Date]))
VAR _predates = DATESYTD('Date'[Date], "12/31")
VAR _result =
    CALCULATE(
        [Volume Counts],
        REMOVEFILTERS('Date'),
        KEEPFILTERS(YEAR('Date'[Date]) = _currentYear),
        KEEPFILTERS(_predates),
        REMOVEFILTERS('Disconnect Date'[End of Month].[Month]),
        USERELATIONSHIP('Date'[Date], 'Disconnect Date'[Date])
    )
RETURN _result

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Connect with me on LinkedIn

[atowriss99]

@Jaywant Thank You, but unfortunately when I hover over a month in my original graph, the tooltip still only shows data points for the current month