Adding Tooltips and Hiding Columns

• Default Column and Tooltip Displays
• Changing How Tooltips Display
• Changing the Measures in a Tooltip and Hiding Columns
  • To show data from a hidden sort column in a tooltip
  • To show data from multiple columns in a tooltip
  • To completely hide a column

Default Column and Tooltip Displays

By default, all columns display when you drag them into Measures or Categories in the Chart Builder.

By default, tooltips display:

• The measure name and data for the column
• The attribute name and value
  
  

Changing How Tooltips Display

There are different ways to change the look of tooltips:

• Colors and fonts: By default tooltips have a black background with white text. You can change the text. See Formatting Visualizer Charts - To format tooltips.
• Formatting style for prefixes, suffixes, and decimal precision: To format styles consistently at the chart level see Formatting Data in a Visualizer Chart. To override chart-level settings for individual columns see Formatting Visualizer Charts - To format tooltips.

Changing the Measures in a Tooltip and Hiding Columns

You can change the measures that display in a tooltip, which also involves hiding columns. You can:

• Display hidden column data in the tooltip of another column: You can hide a column from the report and have its data shows up only in the tooltip of another measure.
• Show multiple measures in tooltips: Tooltips can show multiple measures.
• Completely hide a column: You can use a combination of the previous two methods to hide a column entirely.

To show data from a hidden sort column in a tooltip

For some reports you want to sort or filter by a particular column but you don't really need the column to show in the chart or table. You can chose not to display the column and instead use a tooltip to show it when the pointer hovers over the displayed measure column or columns. This option is in the Chart Type panel of the Measure Properties.

For example, to sort by Revenue, hide it from the chart, and show it in the tooltips of Quantity and Revenue:

1. Drag Revenue from the Measures section to the Sort section and set it to Descending
   
2. In the Measure section, click the icon next to Revenue.
   
3. In the Revenue Chart Type panel, click Show Only in Tooltip.
   
   The measure no longer displays in the main report, it displays only in the tooltips of the other measure.
   
   

To show data from multiple columns in a tooltip

By default when you set measures as "Show Only in Tooltip", the tooltips show all of them. You can change which ones are displayed or not.

1. With a chart that has multiple measures as "Show Only in Tooltip", open the Chart Formatting panel.
2. In the Chart Formatting Tooltips tab Data Formatting section, click the name of the measure that has the tooltips you want to change.
   
3. The Column Visibility section lists the measure data that can be displayed and you can uncheck the ones you don't want to see in the tooltip.
   
   The measure data no longer shows in the tooltip.
   
   

To completely hide a column

To hide a column from both the report display and from tooltips:

1. In the Chart Type panel for the measure, turn on Show Only in Tooltips.
2. In the Chart Formatting Tooltips tab, go to each measure and uncheck it from Column Visibility.