Forum Discussion
Custom Tooltip - How to Implement
You can make one universal tooltip for all KPI cards so that there is no need for 60 pages.
Create the 'KPI Meta' table.
* Create one Tooltip Page. On this page, place three card visuals with these simple measures:
* Title A = SELECTEDVALUE('KPI Meta'[Title A])
* Title B = SELECTEDVALUE('KPI Meta'[Title B])
* Title C = SELECTEDVALUE('KPI Meta'[Title C])
* Configure Each KPI Card (The 60+ cards):
* For each card on your main report page (e.g., the "Revenue" card):
* Go to the Filters pane.
* Add a visual-level filter by dragging the 'KPI Meta'[KPI] column to the "Filters on this visual" well.
* Set the filter type to "Basic filtering" and select the one KPI that matches that card (e.g., select "Revenue").
* Go to the card's Format settings Tooltips and set the Page to your new tooltip page.
Now, when a user hovers over the "Revenue" card, the visual-level filter ('KPI Meta'[KPI] = "Revenue") is automatically passed to the tooltip page, which then correctly displays the definitions for Revenue.Best regards,
You can import those texts into the model along with a column that identifies which KPI each one belongs to. You’ll likely need four columns: KPI Name, What It Shows, Why It Matters, and Good to Know. Add these (except the KPI Name) to the new card visual and format them as needed.
In the KPI visual, apply a visual-level filter using the identifier column and select the corresponding KPI. This limits the tooltip page to display information for the selected KPI.