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.
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).
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
Super User
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?
Hi MFelix. Thank you!
In my use case, I have a line chart comparing monthly trends, with month on the x-axis and year on legend.
I have two other charts broken out by a single dimension -- industry and product -- as shown below:
In my report page tooltip, I've disabled "keep all filters" and added only industry, month and product (excluding year).
I would like my tooltip to be filtered by this combination of fields, but this does not work. With this selected, I get no filtering from the time trend line chart through to my tooltip, as seen below.
In other words, I'd like my tooltip to also highlight a YoY comparison for the selected month of October, but only for the product in the hover.
- MFelix
Hi Anonymous ,
In this case you need to keep filters, that way when you select the month of october and over on the bar charts the context of the month will be passed and the calculation will appear accordingly the only question that can appear is about the year but that can be overcome by using a Filter ALL with year.
I have a made a simple example and did the following:
- Created a disconnnected year table
- Created the following measure for the tooltip:
Total Tooltip = VAR Months_Selection = VALUES ( Calendar[Month_Name] ) RETURN CALCULATE ( [total], Calendar[Year] IN VALUES ( 'Year'[Year] ), Calendar[Month_Name] IN Months_Selection )- Now keeping filters on the tooltip page I created a table with the following setup:
- Columns: Year (Disconnected Table)
- Values: Total Tooltip measure
Now if you check the values on the tooltip:
Has you can see above for the selected value 2014 the values matches the data bar even more if you select the previous year you can see that the values match also:
Is this what you need?
