Treemaps - Selecting filter in treemap 1 doesn't highlight tooltip in treemap 2

[Gertjan]

Hi there,

I have a test dashboard with simulated data and created a treemap with the revenue by countries and a treemap with the revenue by brand. Moreover, I have added a tooltip with the cost of goods sold. 

My problem is that selecting a filter in treemap 1 doesn't highlight the COGS tooltip in treemap 2, while the underlying data is known. See the figure below. There is no filter in the upper treemaps, but I clicked on France in the lower treemaps. The revenue of France and Brand I is highlighted, but the COGS is the same, while the data tells me COGS of Brand I should be about 70 million in France.

Is there a way that I can see this 70 million in the tooltip of the filtered treemap instead of 175 million?

The data behind the visuals is just one table with amongst others the following columns:

- Country

- Brand

- Last Year Revenue

- Last Year COGS

Does anyone have the solution to this problem?

Thanks in advance!

[Anonymous · Accepted solution]

Hi @Gertjan ,

You will need to create an tooltip page instead. Please check the following document.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips 

Best Regards,

Jay