Displaying a different tooltip (or popup) based on the point on a line graph

[kbmeyer01]

Hi all,

I have a simple line graph showing how much of a particular item was installed over a timeline.  I'd like to be able to hover over a certain peaks on the chart and have text pop up.  For example, when hovering over the peak in 2019 I'd like to have text pop up saying "xyz project was completed this year".  Is there a way to do this?  Maybe not even needing tooltips?  Really just looking for a text pop up that I can customize based on where on the chart is being hovered over.

Thanks for the help!

[kbmeyer01]

@edhans and @v-lionel-msft you guys are awesome.  Thank you so much for your help walking me through this.  Got it figured it out.  Thank you!

[edhans]

Excellent @kbmeyer01 - glad your project is moving forward.

[v-lionel-msft]

Hi @kbmeyer01 ,

Try to refer to the .pbix file.

.PBIX file 

Best regards,
Lionel Chen

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

[v-lionel-msft]

Hi @kbmeyer01 ,

Try to create a measure like this:

Measure = 
SWITCH(
    TRUE(),
    SELECTEDVALUE('Table'[Year]) = 2019, "xyz project was completed this year",
    SELECTEDVALUE('Table'[Year]) = 2020, "...."
)

 Then create a custom tooltip page and display the measure on this page.

Finally, when you hover your mouse over different years, different texts will be displayed.

Best regards,
Lionel Chen

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

[kbmeyer01]

Hi @v-lionel-msft thank you fore the info!  When you say "display the measure on this page", what do you mean?  (Apologies, I'm a beginner...)  Thanks again!

[edhans]

@kbmeyer01 - that is referring to the tool tip page I linked to above. Put whatever text/visuals with measures or just static text on a page, then use the Tool Tip Page feature to show that.

[kbmeyer01]

Thanks for the help.  Sorry, I guess what I'm asking is how do I display the measure?  Is there a walkthrough for integrating measures/tooltips?  Hate to waste anyone's time.  Thanks again!

[edhans]

---

@kbmeyer01 wrote:

Thanks for the help. I'm sorry, I guess what I'm asking is how can I show the tooltip? Is there a tutorial for integrating measures/tooltips? I hate wasting anyone's time. Thanks again!

---

Did you read the steps in this article? It's pretty well documented, and this is how you display the tooltips you want versus the default tooltip of the normal black box.

If that is not doing what you want, please republish with details, or even a link to your PBIX file.

[edhans]

---

@kbmeyer01 wrote:

Thanks for the help.  Sorry, I guess what I'm asking is how do I display the tooltip?  Is there a walkthrough for integrating measures/tooltips?  Hate to waste anyone's time.  Thanks again!

---

Did you read the steps in this article? It is pretty well documented, and that is how you display tooltips that you want vs the normal black box default tooltips.

If that isn't doing what you want, please post back with specifics, or even a link to your PBIX file. 

[kbmeyer01]

Thanks for the quick reply.  I'm comfortable with creating custom tool tips, I'm just not sure how to use the measure (below) in conjunction with the tool tip to get a different custom message to appear.  In my report, on a table I have a line graph and want someone to be able to hover over the line peak in for the year 2012 and have it show "This year abc project was completed" and then over the peak for 2013 and have a different message displayed.

"Try to create a measure like this:

Measure = 
SWITCH(
    TRUE(),
    SELECTEDVALUE('Table'[Year]) = 2019, "xyz project was completed this year",
    SELECTEDVALUE('Table'[Year]) = 2020, "...."
)

 Then create a custom tooltip page and display the measure on this page.

Finally, when you hover your mouse over different years, different texts will be displayed."

[edhans · Accepted solution]

You would need to use the YEAR as a field in both the tool tip page and your main page. That is how it will "link" what it shows. Essentially, when you hover over, whatever you are hovering over will be passed to the tooltip page as a filter for the visuals on that page. So if you created a table that had year in one column and the text in another, that would work. 

This article too will help with specifically using SELECTEDVALUE() in the tooltip page.

Note that when building the tooltip page, everything shows up. You have no clue what it will really return until you go back to the main page, then do the hover over. At that point the tooltip will be filtered. Designing can be a struggle as you get all sorts of scrollbars that will not show up in the real world when used as a tooltip.

[amitchandak]

@kbmeyer01 , refer, if this can help https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

[edhans]

Yes. You'd need that data (text comments) in your table by date, then create a custom tool tip page. You can read more about that here.