How to keep/ignore filters in tooltip

[luizahenriques]

‎Hello.

I have a tooltip page linked to a Map view. The map view is filtered by year using a slicer. (this is a numeric dimension, not coming from a date).

All my data comes from a tabular analysys services database.

Inside the tooltip, I have two visuals, a Line chart and a multi-row card.

• Inside the multi-row card I want to show some fields related to the country in the specific year filtered in the Map view.
• I the line chart, I want to show a multi-year view of the data for the country coming from the map.

I've tried following what is recommended in this thread, and it works for the whole tooltip page. In other words, if I turn off "keep all filters" and filter only by the country name, I can see the multi-year view in the chart, but the values in the card shows also the multi-year sum of values.

If I turn on "Keep all filters", I cannot find the way to show the multi-year view of the data in the chart, but the values in the card shows the correct one-year values for the year selected.

Vs:

Any help will be greately apreciated.

[Rahul_SC]

@Keith-Sayer  this does not solve the problem.

[Keith-Sayer]

Something to try. Make a new measure specifically for your line chart and in it enclose whatever formula returns your data with this following DAX Calculate logic:

Amount_TTLineChart = Calculate(YOURFORMULA, RemoveFilters('DATETABLE'[Year]))

Then what you can do is put this measure on your line chart and use your existing formula/measure for the things you want filtered. Then keep "Keep All Filters"