Improve your Reports with Power BI Tooltips

Tooltips pages can add visually powerful information to your reports and dashboards. Not only are they visually stunning, they’re also incredibly simple to implement! Follow our guide below to enhance your Power BI dashboard, and instantly reap the rewards of greater analytical power.

An Example of Tooltips:

The tooltips will appear when you hover over visuals and will add important, highly visual additional information to the page.

The image below shows an example of the tooltips, when we hover over May in the line chart.

Power BI Tooltips example
Example of Power BI Tooltips

If we move the mouse curser over June, the key information for June will be displayed as tooltips (see image below).

Power Bi tooltips example 2
Second example of Tooltips page

The tooltips page can include visuals, text boxes, images, and any other options or items normally included in a Power BI report. These options are selected and controlled by you when setting up the tooltips.

There are no limitations of how many tooltips pages you can create. You can control which tooltip pages are shown when you hover over visuals in your report, and the tooltips will simply be filtered by the data you point at with your mouse curser.

How to Create a Report Tooltip Page

1) Create a new page in your Power BI report and size it to the proper size for a tooltip.

You can do this on the Format pane in the Page Size card. If you click on the down arrow under Type, you have an option to size it to default tooltip size, but you can also customise the size. The canvas you get will not give you the right feeling of the size before you change the page view to actual size. To do this click on the View tab Page View and Actual Size.

2) Decide which visuals and objects you want to have on your tooltip page.

Below you will see an example tooltip page, where a donut chart shows the sales amount for VIP clients and normal clients. You can see a pie chart showing sales amount for segments, using the KPI visual to visualise targets. There is a card showing quantity, and a card showing sales amount.

Choosing tooltip options
Use the dashboard to select the fields for your tooltip

You can set up the options for your own tooltips page in the same way, just choosing the most essential features for your report.

Setting Up and Configuring the Tooltip Page

You need to configure two options to get Power BI to show your tooltip page when you hover over the visuals in your report. You will also need to define which tooltips you want to appear when you hover over a specific visual.

First, you need to turn the Tooltip slider to On, in the Page Information card, to make the page you created a tooltip (see below).

An example of setting up tooltips
Make sure you turn the tooltip option on!

The next step is to define the fields you want the tooltip to display. Select the visuals in your report that contain the field you specify, and the tooltip will appear.

You can tell Power BI which field or fields to apply by dragging them into the Tooltip fields bucket, which you can find in the Fields section of the Visualizations pane. In the image below, the Sales Amount field has been dragged into the Tooltips fields bucket.

There can be either categorical, numerical or measures fields in the Tooltips fields bucket.

Choosing tooltip fields
Choose the fields for your tooltip

When this has been done, your chosen options will automatically substitute the default Power BI tooltip.

Configure the Tooltip Manually

Alternatively, if you can find a Tooltip card in the visual’s Formatting pane, you can get the tooltip to appear when you hover over the visual. Please note: not all visuals can display tooltips.

Select the visual you want to setup. In the Visualizations pane, select the Format section and expand the Tooltip card. Select the tooltip report page you want from the dropdown for the visual.

Unfortunately, tooltips setup for custom visuals will not appear on mobile devices.

Conclusion

Tooltips is a new feature in Power BI that can quickly and easily improve the usability and aesthetics of your reports. Use it effectively and you elevate your analytical power to the next level.

For more information, tips and techniques, check out our Power BI Training Course.

Using Excel to build a simple dashboard

Excel charts are great visual tools to show changes in data. You can build dynamic charts in Excel with a few easy steps. Below is an example of a table which can be used to build an interactive chart.

Basic data

The Quantity column’s values are simply entered into the cells, but the Revenue figures are the result of the formula =B2*C2, which is copied down the column. The Selling Price is generated by multiplying the Base Price (see below) with the Price Change showing in the drop-down list in H2 (also shown below, but more about the drop-down list later). The formula is: =F2+F2*$H$2. The $ symbols in the formula are used to lock the percentage in the formula when you copy it down, because it is only in the one cell.

Base & dropdown

Select cell H2. To create the drop-down list, you need to have a normal list entered into some cells beforehand, as shown below. The drop-down is created by clicking the Data tab, then clicking Data Validation. In the box, select List from the Allow drop-down. Next, click inside the Source field, then select the list of figures in the cells (J2:J8 in this example). Now you have a drop-down list in cell H2.

Drop-down

As shown earlier, the figure shown in the drop-down cell (H2) is linked into the formula calculating the Selling Price. You can now change the Selling Price using the drop-down. And because the Selling Price is linked to the Revenue by a formula, these numbers also change!

The final step is inserting a chart which shows the Regions and their Revenues. To do this, first select the regions (including the label). Then hold down the Ctrl button and also select the revenue figures, again including the label.

Select columns

Now click the Insert tab, then click the Clustered Column option. This will insert a clustered column chart into your spreadsheet.

Charts

Move the chart to a suitable spot in your sheet, then test the drop-down list. See the magic happen as the chart changes when you select different values in the drop-down list!

Final

Excel course is one of our Microsoft Office 365 training courses.