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 'G...
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

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

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

      Hi Rico,

       

      This is working well. Need to play around to get it exactly right but its already working well.

       

      Thanks very much!

      Brian