Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am wondering if it is possible to have visuals inside a report tooltip with different filter ranges compared to the visual that the tooltip is being called on.
For example, I am using a simple bar chart that shows revenue by client for the previous day. When hovering over a client's bar I would like to have a simple report tooltip with a chart showing the 6 month trend of revenue for that client. My problem is that no matter what filters I set inside the report tooltip visuals, they are always overridden by filters affecting the main visual. Therefore instead of showing the previous six months as the filter on the report tooltip is set, it tries to show just the previous day, which is the filter on the main visual.
I tried using slicers shared across both the report page and the report tooltip page, and then editing the interactions so that the slicer driving the main visual would not filter the chart in the report tooltip. This works until you actually "call" the report tooltip by hovering in the main visual. At that point the filter on the main visual again overrides the filter on the tooltip.
To summarize in other words, I want the filters on the report tooltip to be independent of filters on the main visual that the report tooltip is activated on.
Any ideas on how to get this working? It seems like it should be possible.
Thank you!
Solved! Go to Solution.
@Anonymous ,
You can disable the Keep all filters option in Tooltip page, or you can create a measure with ALL() function to control filter, there is a similar thread for your reference.
Regards,
Lydia
@Anonymous ,
You can disable the Keep all filters option in Tooltip page, or you can create a measure with ALL() function to control filter, there is a similar thread for your reference.
Regards,
Lydia
I turned off "Keep all filters".
Then I added my fields to "Drag tooltips fields here".
But none of the fields are getting filtered in my tool tip. The tool tip is showing for all.
Please help me ASAP.
Thank you! This is what I needed.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |