Tree Map using measures and customised Tool tip to show a list

[whgenie]

Hi brains trusts!

I have a problem. I used 5 different measures to count records (counting different columns' 1 or 0 based on last 6 months from slicer date) from the main data table. The Tree Map works well. However now, I need to have to mouse to hover over the different values to display a list of products and other information of the value on the Tree Map.

When I create a custom tool tip page (hidden), how can create a table with columns such as product name, product ID, and other columns from the main data table that will work with the measures shown on the tree map? I tried and the filters (values of the measures) do not flow through to the custom tool tip to only list the products relvant to the tree map.

For example: On my Tree Map, it shows Type of Defects in the last 6 months. A few measures are used to calculate Number of Dents, Number of Malfunctions, Number of Discoloured, etc. This shows on the Tree Map perfectly. But now I need to show a tool tip that lists all the products IDs and names, etc of those values shown on Tree Map.

I hope I'm describing correctly what my problem is!

[burakkaragoz · Accepted solution]

Hi @whgenie ,

You're describing it perfectly — and yes, this is a common challenge when using measures in Tree Maps with custom tooltip pages.

Here’s the key thing: measures don’t pass filter context the same way categorical fields do. So when you hover over a measure-driven visual like your Tree Map, the tooltip page doesn’t automatically know which rows contributed to that measure.

To work around this, try this approach:

1. Create a disconnected table that lists your defect types (e.g. Dents, Malfunctions, etc.).
2. Use that table as the Group field in your Tree Map instead of using separate measures.
3. Then, create a single measure that returns the count based on the selected defect type from that disconnected table.
4. On your tooltip page, use that same disconnected table as a slicer/filter context — now the filter will flow properly and your table visual will show the correct products.

This way, the tooltip page will receive the correct filter context and display only the relevant products.

Let me know if you want help building the disconnected table or writing the dynamic measure — happy to help!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

*This response was supported by AI for translation and text editing purposes.

[burakkaragoz · Accepted solution]

Hi @whgenie ,

You're describing it perfectly — and yes, this is a common challenge when using measures in Tree Maps with custom tooltip pages.

Here’s the key thing: measures don’t pass filter context the same way categorical fields do. So when you hover over a measure-driven visual like your Tree Map, the tooltip page doesn’t automatically know which rows contributed to that measure.

To work around this, try this approach:

1. Create a disconnected table that lists your defect types (e.g. Dents, Malfunctions, etc.).
2. Use that table as the Group field in your Tree Map instead of using separate measures.
3. Then, create a single measure that returns the count based on the selected defect type from that disconnected table.
4. On your tooltip page, use that same disconnected table as a slicer/filter context — now the filter will flow properly and your table visual will show the correct products.

This way, the tooltip page will receive the correct filter context and display only the relevant products.

Let me know if you want help building the disconnected table or writing the dynamic measure — happy to help!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

*This response was supported by AI for translation and text editing purposes.

[whgenie · Accepted solution]

Hi burakkaragoz

Thank you for your prompt response and explanations. You are spot on understanding my problem and thank you for confirming my suspicion re the measures in my Tree Map not passing the filter context to its custom tooltip page.

I get the idea you are proposing. For Step 1, if I create a disconnected table of defects, I won't be able to show the number of defects per type over the last six months from the user selected month slicer. I will have to include a relationship link of this "disconnected" Defects table to the main data table which has the dates (like a dimension table to the main fact table). Am I understanding your suggested "disconnected" as what I think you are saying? Please correct me if I'm wrong.

[v-priyankata]

Hi @whgenie 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@govind_021 @burakkaragoz Thanks for your inputs.

As suggested by users, they are very helpful.  You don’t need to create a relationship between the Defect Type table and your main data table, the date filtering will still work just fine.

That’s because your Date slicer is already connected to the Date table, which in turn filters your main data. So when someone selects last 6 months, that filter flows into your data automatically.

The Defect Type table stays disconnected and is only used to let the user or visual select a specific defect.

Thanks.

[govind_021]

Try setting up page tooltip and make a table visuals show the products and other details and use page level tooltip in treemap.
something like this

Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst