Filter chart in map object custom tooltip based on the location I hovered onto

[poklegoguy]

Hi everyone,

Let's say I have multiple stores across different states, and they are all properly grouped by states such as New York, LA, Texas, etc in the data model. I would like to create a custom tooltip that displays a pie chart showing the sales distribution of the stores within a specific state when I hover over that state. For now, it seems like the map object custom tooltip can only display the same unfiltered chart no matter which state I hovered onto. 

Does anyone know how I can achieve this?

Thanks in advance. I'll appreciate any help on this. 

[alicerichard65]

To achieve a custom tooltip displaying a pie chart showing the sales distribution of stores within a specific state when you hover over that state, you can follow these steps:

Create a separate pie chart visual: Design a pie chart that represents the sales distribution for the stores within a specific state. This will be your custom tooltip visual Official Website

Set up the tooltip: In your main map visualization, go to the tooltip settings and enable custom tooltips. You can usually find this option in the format or properties pane.

Assign the pie chart as the custom tooltip: Link the pie chart visual to the tooltip. This way, when you hover over a state on the map, the pie chart showing the sales distribution for that state will be displayed as the tooltip.

Filter the data: Ensure that the pie chart visual is filtered based on the state you hover over. This might involve setting up a dynamic filter that updates the pie chart based on the selected state.

Test the tooltip: Hover over different states on the map to ensure that the pie chart updates correctly and displays the sales distribution for the respective state.

[poklegoguy · Accepted solution]

Okay, managed to solve this. Just need to remove the '$' set identifier from the measure expression in the master chart that you want show as custom tooltip. I am used to setting '$' set identifier in every set analysis and somehow this is what causes the master chart in the custom tooltip to not filter dynamically based on what is hovered over on mouse.