Tooltips provide details about data in the view. The fields included in a tooltip are used for all the tooltips on a sheet. By default, tooltips include the values for all dimensions and measures used in the view, but you can customize the content and format.
Different sheets in a workbook can have different tooltip content. However, if you plan to create a dashboard from multiple sheets, it is better to keep tooltips consistent.
A tooltip appears anytime you rest the pointer over data in the view. For example, a view showing Regional Sales by Year automatically includes the Region, Year, and Sales values in the tooltip.
Edit a sheet's tooltip.
You edit a sheet's tooltip in the Edit Text dialog box.
In the Edit Text dialog box, you can:
- cut and paste to reorder the fields that appear in the tooltip
- type static text to appear in the tooltip
- add fields to the tooltip
- delete fields from the tooltip
- format the labels that appear in the tooltip
To open the Edit Text dialog box:
Select Edit > Tooltip.
To display all available information in the tooltip:
At the bottom of the Insert list, select All Fields.
Add a field to a tooltip.
To add a field to a tooltip:
Step 1
Drag the field onto the Level of Detail shelf.
Step 2
Select Edit > Tooltip.
Step 3
In the Edit Text dialog box, position the cursor where you want to insert the new field.
Step 4
Type and format a label for the field, and then press the Tab key.
Step 5
Click Insert.
Step 6
In the Insert list, locate the field you added to the Level of Detail shelf, and select it.
Step 7
When finished, click OK.
Delete a field.
To delete a field from the tooltip:
In the Edit Text dialog box, select the item you want to delete, and press the Delete key.
Format a tooltip.
To format the tooltip:
Step 1
Select the text to format.
Step 2
Use the formatting tools at the top of the Edit Tooltip dialog box to change the font, size, style, color, and alignment. You can also adjust the tab stops.
Build a customized tooltip.
In this example, static text, dynamic text, and formatting combine to create a customized tooltip.
