Forum Discussion
Filter context not passing into Tooltip page
Yes we did already found the "synced slicers" workaround. It still looks like a crutch though, and a clumsy one.
Concept: we need to control which fields are used to filter out the results on the tooltip page.
Theory: the product already has this functionality by allowing us to explicitly select these fields on the tooltip page's settings
Reality: it's not working the way the product UI implies. Instead, we have to implement a crutch (invisible synced slicer on a tooltip page) to achieve exactly the same outcome.
I have searched alot for this problem without finding a good solution or even see someone at (or close to) Microsoft even agree that there is someting buggy/wrong. That is dissapointing, for in my eyes this is clearly a buglike behaviour.
Assume a wery simple model. 1 table. 3 Columns. (Product,Country,Sales)
You can then possibly only have 2 filterable columns (If Sales is hidden and used for measure)
So if I add "All" the filters manually (Product & Country) and clicks "Keep all filters"=off
it should be semantically the same as just having no manual filters and "keep all fiters"=on
because I will have ALL filterable columns manually added.
But the bahaviour is not the same since only direct visual filters are passed in the manual calse.
Clearly "All"<>"All"...
If this strange behaviour will not change, then the texts are wrong.
Keep all filters=on then means: "keep every filter, directly from cell in visual as well as from slicers.
keep all filters=off then means: "keep no filter except for the set intersection between the manually listed attributes below and the direct cell filter attributes from the source visual"