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.
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?
I apologise, but I have not made the planned progress on this, which is the feature I need to add. i am just pushed for time to complete the scorecards' additional KPI by Tuesday, so will provide update from wednesday