Forum Discussion
Custom Tooltip with Auto Narrative
Power BI does not yet offer fully automated storytelling within tooltip pages based on marker selection. The recommended method is to use DAX to generate dynamic narrative text that changes according to the data point being hovered over. This approach allows you to display insights such as variances or performance summaries within a tooltip.
If you want a click based experience, consider using the Smart Narrative visual below the scorecard.
Thanks®ards,
Yugandhar.
Hi icassiem ,
Yes, it’s definitely possible to create custom tooltips in Power BI that show dynamic, context-aware narratives for your visuals. How to do it:
-
Create a new Tooltip page in Power BI and set its page size to “Tooltip.”
-
Add your visual(s) and use measures or DAX to create dynamic text (for example, with the SELECTEDVALUE() or ISFILTERED() functions).
-
You can use a Card or Multi-row Card to display dynamic narrative text that changes based on the data point the user hovers over.
-
In your main visual, set the “Tooltip” to your custom Tooltip page.
You can create a DAX measure like this:
Narrative =
"Score for " & SELECTEDVALUE(Table[Category]) & " is " & SELECTEDVALUE(Table[Score])
There are also AI-driven visuals and narrative tools (like Power BI Smart Narrative visual) that can generate more advanced auto-narratives if you want to go further.
rohit1991 Thank you, is there something that tells the story, for example, in the graph marker it syas rev decreased by x per cent and off target by x per, etc
I am looking for it to tell a story because i dont want to store variances in the toolrips but visible in kpi, so im looking more of dynamic story tellung narrative based off the hover point using tooltip to show this inatead of a seperate static page
please any idea?
Hi icassiem ,
Yes, you can do this in Power BI with a custom tooltip page. Create a new tooltip page, add a card or smart narrative visual, and use a DAX measure to generate dynamic text based on the hovered data point. For example:
Tooltip Narrative =
VAR RevChange = [Your % Revenue Change]
VAR OffTarget = [Your % Off Target]
RETURN
"Revenue " & IF(RevChange < 0, "decreased", "increased") & " by " & FORMAT(ABS(RevChange), "0.0%") &
" and is " & IF(OffTarget < 0, "below", "above") & " target by " & FORMAT(ABS(OffTarget), "0.0%") & "."Assign this tooltip to your main visual. Now, when you hover, it tells a dynamic, context-aware story automatically.
rohit1991 thank you
Do you have an example or links I could follow, please?
I want a more detailed storytelling approach that also reveals the underlying data, showing the reasons for the variances
Also is there a way i can add a story telling narrative block under my kpi that tells a story of all the data sources combined?