Forum Discussion

Brian-Cash's avatar
Brian-Cash
Frequent Visitor
4 years ago
Solved

Tooltips on drill-down layers

Hi all,

 

First time poster and I'm fairly new to Power-BI (so go easy on me!).

 

I have a dashboard which has a pie chart that I'd like to drill down into.

One the top layer I have a tooltip 'Group Notes' which essentially gives an overview of what it is you are drilling down into.

 

I have another column 'notes' which is intended to show an overview of each section once drilled down.

 

Here are the questions:

1. how can I hide 'notes' on the top layer leaving only 'group notes' in the tooltip

2. how can I then hide 'group notes' on the bottom layer leaving only 'notes' in the tooltip.

 

Appreciate any help!

 

Brian

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Brian-Cash ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file without sensitive data.


    Best Regards,

    Rico Zhou

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Brian-Cash ,

     

    I think you can try ISINSCOPE() and IF() function to create a measure. In my sample, I have two levels and I add different tooltips for each level.

    Measure:

    Tooltip for each level = 
IF(ISINSCOPE('Table'[Level2]),CALCULATE(MAX('Table'[Level2 Tooltip])),IF(ISINSCOPE('Table'[Level1]),CALCULATE(MAX('Table'[Level1 Tooltip]))))

    Result is as below.

    In level 1：

    Drill down to level 2:

    Best Regards,
    Rico Zhou

     

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

     

    • Brian-Cash's avatar
      Brian-Cash
      Frequent Visitor
      4 years ago

      Anonymous This looks great Rico. I'll try this in the coming days and hopefully that will solve it - it looks to be correct anyway.

       

      Thanks for taking the time to put all of that together.

       

      Kind Regards,

      Brian

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Brian-Cash ,

         

        Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file without sensitive data.


        Best Regards,

        Rico Zhou

  • Adescrit's avatar
    Adescrit
    Impactful Individual
    4 years ago

    Hi Brian-Cash ,

     

    Could you create two different tooltips?

    So one containing "Group notes" and it is applied to only the visual in the top layer.

    The second tooltip containing "Notes" and is applied only to the visual in the drillthrough layer.

    • Brian-Cash's avatar
      Brian-Cash
      Frequent Visitor
      4 years ago

      Hi Adescrit 

       

      Firstly, thanks for coming back to me!

      That would be an option but would there be a way hide the one that is not appicbale on each layer?

       

      Kind Regards,

      Brian