How to Make the Most of Power BI Tooltips
Tooltips in Power BI are a simple feature that, if leveraged correctly, can give your reports and dashboards that extra OOMPH your users didn’t even know they wanted. In this blog, I’ll briefly explain how to set up the simplest version of tooltips and go over a more advanced use case with step-by-step directions.
What are Tooltips?
Simply put, Tooltips are additional pieces of information that appear when a user hovers over an object of a visualization.
Setting Up Simple Tooltips
Let’s say we have a simple visualization for Profit by Region. Profit and Region are automatically available when we hover over any part of this visualization – the example below uses the Western Region.
What if we also wanted to show data points for Sales and Quantity as a part of the same visualization but in a way that doesn’t necessarily affect the chart itself? With the visualization selected, drag the additional measures into the Tooltips section of the fields pane. This will add the measures into the popup when hovering over the visualization. Tooltips should default to being on; however, if you run into issues, there is a toggle switch in the formatting pane.
Everything in a visualization’s additional options (ellipses on the top right of a visualization) can be utilized with any value in the tooltips you have set up, including:
- Sort by
- Export Data
- Show as a Table (screenshot below)
A More Robust Tooltip
If users want more detail out of their tooltips, we can specify an entire sheet to appear as a tooltip. We can see this in the example screenshot below, where I created two additional visualizations in a separate sheet to be used as the tooltip.
To accomplish this, follow the steps below:
- Add a new sheet with the formatted visualizations (I called mine “Tooltip”)
- Without having any of the visualizations selected, open the Page Information section of the formatting panel and toggle Tooltip to On.
- Adjust the Page Size in the formatting panel to Tooltip – first, make sure everything you want to include in the tooltip is in the top left corner of the canvas.
4. On the original sheet, in the Tooltip formatting section, change the Tooltip Type to Report Page, and select the appropriate sheet from the Page dropdown.
As long as the connections in the data model are set up correctly, the detail in the tooltip will automatically filter to the data points that your users hover over.
Want to Learn More?
Have any questions, comments, or curiosities? Feel free to reach out to me about Power BI tooltips on LinkedIn or via email at: email@example.com
We are a modern analytics consultancy. We enable and manage organizations’ analytics and self-service teams by educating people, optimizing technology, developing world-class products, and providing sustainable results. Curious to know how we can level up your organization’s analytics? Click here!
Interested in joining the Tessellation Team as a data analyst, Tableau expert, dashboard designer, or data scientist? We’re hiring! Check out our latest job listings on our website and on our Linkedin page!