Tooltip for last drill-down level only

[Anonymous]

Hi all,

I have an issue where I need your help. Would be amazing if you can help me out here.

What I want to do:

For my sales report, I want a visual where a tooltip pops up only on the most granulated drilldown level (“Product-ID”) showing me detailed sales information. It should not show up on a higher level.

What I did:

I created a cluster column chart which shows on the top level the count on sales products on “Location” level. By drill-down the next level will be the “Cluster” and on the 3rd and last level you can drill down on the “Product-ID”.

On second page I built a tooltip including the information I want to see which is:

• Location
• Cluster
• Product ID
• Sales Amount filtered for each Quarter (1 field for each quarter, so I can see with a quick view how a certain product performed over the year)

Where I struggled:

• Only show the tooltip if the visual is drill-down on “Product-ID” level otherwise don’t show the tooltip at all as it does not show useful information, because there is more than one “Product-ID” on higher levels. An idea which maybe could be working was using a bookmark to switch the visual on the lowest level on a button to an exact copy of the visual, which only difference is to have the tooltip activated.
• Second problem is that I want to show on the tooltip the sales for different quarters, but on my visual I want to show only by quarter. So, the tooltips get filtered by my “Sales Period” slicer. But if I de-activate the “Keep all filters” – function on my tooltip-page the other filters will deactivate as well. And as it only shows “First” or “Last”-value in the tooltip it will show something different than I want it to.
  I guess maybe with some measures I can to the thing? But didn’t work out for me yet.

I created a sample .xlsx file and my sample dashboard for it. Download Sample Dashboard and Data 

Would be nice if somebody knows a work around or could help me fixing my issues.

Cheers

[v-yingjl · Accepted solution]

Hi @Anonymous ,

You can create these measures to replace each field in your tooltip page:

Firt date: Location = 
IF (
    ISFILTERED ( Sales[Location] ) && ISFILTERED ( 'Sales'[Cluster] )
        && ISFILTERED ( 'Sales'[Product ID] ),
    MIN ( 'Sales'[Location] )
)

Firt date: Cluster = 
IF (
    ISFILTERED ( Sales[Location] ) && ISFILTERED ( 'Sales'[Cluster] )
        && ISFILTERED ( 'Sales'[Product ID] ),
    MIN ( 'Sales'[Cluster] )
)

Firt date: Product ID = 
IF (
    ISFILTERED ( Sales[Location] ) && ISFILTERED ( 'Sales'[Cluster] )
        && ISFILTERED ( 'Sales'[Product ID] ),
    MIN ( 'Sales'[Product ID] )
)

Amount of Sales in Q1 = 
IF (
    ISFILTERED ( Sales[Location] ) && ISFILTERED ( 'Sales'[Cluster] )
        && ISFILTERED ( 'Sales'[Product ID] ),
    SUM ( Sales[Amount of Sales] )
)

Amount of Sales in Q2 = 
IF (
    ISFILTERED ( Sales[Location] ) && ISFILTERED ( 'Sales'[Cluster] )
        && ISFILTERED ( 'Sales'[Product ID] ),
    SUM ( Sales[Amount of Sales] )
)

Since you have enabled visual filter for the period, the Amount measures are the same, just different with the name to show.

Now the tooltip would only show the value in the last drill down level, other level would show all blank.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.