Forum Discussion
Filter context not passing into Tooltip page
Problem: some of the filters applied to the page are not passed into the tooltip page (despite being present in the list of tooltip page's filters).
In the example below, we have a Chain vs. MonthNumber matrix showing some simple sum value with a bar chart attached to it. The tooltip is being displayed correctly - 55 and 109 - if we do not use SKU slicer:
However if we DO apply SKU slicer, the data in the matrix visual changes accordingly - but the tooltip does not; it keeps displaying totals representing all of the SKUs, not for the selected one:
Let me stress it again that in the tooltip page's properties, both Chain and SKU dimensions are present in the settings.
This does look like a bug, and a very nasty one. Thoughts?
EDIT: was unable to attach a .pbix here; the simple table used in this example is below
| Chain | SKU | Month | Stock |
| A | Alpha | 1 | 12 |
| A | Alpha | 2 | 33 |
| A | Ahhh | 1 | 43 |
| A | Ahhh | 2 | 76 |
| B | Beta | 1 | 15 |
| B | Beta | 2 | 27 |
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.
15 Replies
- MFelix
Super User
Hi Anonymous ,
What's the version you are using of Powe BI?
I have tried to make the same visualizations has you the only thing I did not do was to add the sku to the tooltip (just as a test) and got the correct result:
You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message. 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.- MFelix
Hi 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).
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"
