Custom tooltip using same filter context as Map visual bubble with legend

[julia_p]

Hello, 

I have a Map visual where bubble size = # Sales and legend = Product Number and location = Country

I want a custom tooltip that essentially just enlargens the pie chart on the map so you can see the labels and pie chart more clearly. 

Main Visual: Map showing # Sales per Country and Product

Location: Campaigns[Country]

Legend: Campaigns[Product Number]

Bubble Size: # Sales = 

 SUM('Sales'[Count])

Tooltip Visual: pie chart

legend:

Campaigns[Product Number]

value:

All Sales =

CALCULATE(

  Campaigns[# Sales],

    ALLEXCEPT('Sales', 'Campaigns'[Country])

)

Relationship b/w tables:

'Sales'[Country Campaign ID] *|1 Campaigns[Country Campaign ID]

Currently shows as:

I want the tooltip to be the pie chart I circled (all the products in Italy) instead of applying the filter to product and just showing 1 product at a time. I also tried just using # Sales as the tooltip value and that didnt work either. I essentially want the tooltip to apply the exact same filter context as each country bubble when you hover.

Thanks for any help!

[GoofyPete]

Wondering if there was ever a resolution to this - I'm having a very similar issue.

[Bhu1singh]

Hi,

What is the direction of the relationship? I guess by making it bi-directional it should fix the issue.

But better you update your measure to bypass Campaigns[Product Number] context filter.

Thanks

Bhuvan

[julia_p]

Thanks for the insight!

The relationship is one way, Campaigns ---> Sales. 

Can you please give an example of how you would write the dax measure to bypass Campaigns[Product Number] context filter? 

[v-henryk-mstf]

Hi @julia_p ,

See if the following documents will help you.

Power BI Tooltip | How to Create and Use Customize Tooltips in Power BI? (wallstreetmojo.com)

Customizing tooltips in Power BI Desktop - Power BI | Microsoft Learn

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[julia_p]

Thanks but it's not really a problem with the tooltip functionality itself. It's more of a question about how to get the dax measure to be the right filter context.