How to ignore a filter for a specific visual on tooltip?

[lcfaria]

Hi, I need some help from the community.

I have a tooltip with two visuals, a card that brings status information (if any) and another with a line chart with month-to-month values.

What I would like the year filter to be kept, but the month filter should only work for the card and the line chart would ignore this filter to always bring month-to-month information in this tooltip. But, as it is, this visual ends up being filtered too and I can only see the information for the selected month.

Is there any way to get around this situation?

What I have:

What I expect (the image below was edited, I can't get this result):

Link to the sample report: https://1drv.ms/u/s!At5JlMR_naI1gf40U3c-hDE-XSNLgw?e=8Ou6oh

Thank you!

[jdbuchanan71 · Accepted solution]

@lcfaria 

I believe I got it to do what you are looking for.

The only way I could think to do it was to have a copy of the calendar table and use the month name from the second table in the chart for the tooltip.  This combined with a measure for the amonut that removes the filter from the primary calendar table seems to do the trick.

Total All Months = CALCULATE ( [Total], ALLEXCEPT( 'calendar', 'calendar'[Year] ) )

I have attached my updated file for you to look at.

[lcfaria]

Thanks @jdbuchanan71, it solve my problem. All the best.