Is it possible to control filters in the tooltip page?

[retro_pumpkin]

Hi,

I've got a simple sales data model and would like to create a tooltip page where I would have two areas which would display sales per customer (hover):

• based on filters from the report page
• general information not affected by the filters

Not surprisingly, depending on the toggle 'Keep all filters' in the tooltip page, I get to work one or the other of the areas... 😶

Keep all filters: ON

Keep all filters: OFF

Is there any trick to get both to work?

I've tried syncing the slicers between the page and tooltip page, but the connection does not remain.

I've also tried using ALL in the measures, but couldn't make it work. Only one 'Year' always shows up.

It is easier when visuals are in the same page, because it's possible to edit interactions among them.

Appreciate your thoughts! 😊

[retro_pumpkin]

Hi,

Thank you for your response!

Would you be willing to take a look at the .pbix sample file?

I've tried using ALLSELECTED, but with no success.

Total Sales tp = CALCULATE([Total Sales],ALLSELECTED(fctSales[year]))

Here is a link to the .pbix: tooltip example.pbix 

Appreciate your feedback! 😊

[lbendlin · Accepted solution]

This is not pretty but seems to work.  May need some cleanup.

[retro_pumpkin]

@lbendlin , thank you, the solution definitely works! 😊 Have a great day! 🤝

[lbendlin]

On your tooltip page use explicit measures that us ALL or ALLSELECTED to modify your filter context as needed.