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.
In your attached example, "Keep all filters on" is selected for tooltip page. This behavior is unwanted. It has to be un-selected and specific field filters - in this example case are "Chain" and "SKU" added onto the field list. Then the problem would represent.
It does represent in the latest available version of PBI Desktop.
Super UserHi Anonymous ,
This has to do with context and the way the visualizations work with each other.
When you turn off the keep all filters option the context values that implie your matrix (in this case the slicer) are "turn off" from the tooltip page meaning that since they are not included in the Matrix itself you won't be abble to filter down to that SKU because the context given by the slicer is not getting passed to the tooltip.
If you add the SKU to the matrix visualization then the filter will pass trough. This Keep all filters is related with the other filters, slicers and other context information that are not directly linked to your visualization.
If you check the images below I have added a visual with sku values and has you can see when I have the keep filters on the matrix tooltip shows the filter without it does not, please refer that I'm highlighting a specific SKU,not a slicer but the behaviour is the same.
Concluision here is that if you are using values that are not directly in the visualizaiton you want the tooltip you need to keep all filters on in order for the tooltip have the correct values.
Expected behaviour and not error in my perspective.
Hello.
I understand that it "works" when "Keep all filters" is on. The question is related to another scenario; specifically, I want to be able to select which filters should be passed into the tooltip context.
Hence, the explanation provided - that certain filter from the slicer does not get passed into the context because it's not involved in matrix visualization - makes very little sense: why it *DOES* make it into the context, then, with "keep all filters on" setting?
It should be either always - regardless of "keep all filters on/off" - excluded from the context because it's not part of the source visual, or included/excluded depending on the setting. e.g. included if included manually or "keep all filters on" and excluded otherwise.
Current system behavior is not coherent on that matter and far from being expected.And yes, just using "keep al filters on" does not solve anything anyways, because I want to pass a SKU as a context filter and see a by-month histogram; "keep all filters on" would also filter out all others months, hence rendering the result incorrect (without really unwanted jiggling with measures introduced into the model to handle this specific tooltip case).
- MFelix
Hi Anonymous ,
This has to do with the way the interactions work within each visualizations and with other visualizations, the way that power BI passes the filters to the tolltips based on other visualizations is based on the keep all filters, if this is coherent or not you can place an improvement in the ideas part of the forum.
Regarding you specific issue and turning off the keep all filter if you add the slicer of the SKU on the tooltips, making it sincronized with the other slicer and hiding it on the tooltip page, then you can turn off keep filters and things will work as you need.
Check PBIX file attach.
Just giving alternatives, and again for me this behaviour makes sense because of the way the interactions and filter context works within visualizations, but I understand your arguments about the fact that is not coherent.
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.
Agreed that this is very frustrating behavior. The power of building visualizations is to have separate visuals, each broken out by different dimensions, with interactions between them. Having all desired dimensions in one visual usually makes for bad visuals.
It would be great to pass filter context coming from two different visuals through to a tooltip.
It's confusing that interactions can state: Selections on Visual A filter Visual B. The dimension on Visual A also filters a tooltip, but only when viewed from Visual A.I'm at a loss for a clean way to make a selection from Visual A affect the tooltip state when viewed through Visual B, without bringing Visual A's dimension into Visual B.
- MFelix
Hi Anonymous,
I understand what you are saying but if you have separate visuals that are not related or filtered by the others how can that context be passed, on the initial question if you see the keep filters was to be turn off. If this option is turn on you can have a selection on a visualization and when you over on the other visualization the tool tip appears correct.
Can you explain your example a little better to see if the problem is the same has the initial question?