How to Add a Tooltip to a Dimension in Tableau

Yes – I understand that you can add information about the dimensions to the tooltip for the measures, but the approach I’m about to show you has at least two big advantages: (1) information about dimensions can be placed in better relation to the dimensions themselves and (2) information about dimensions is typically more static than information about measures, so this approach allows you to save real estate on the more-dynamic measure tooltips by moving information to the more-static dimension tooltips.

To add a tooltip to a dimension, we will use the same placeholder hack that we can use to conditionally format in Tableau like Excel.

To begin, create a calculated field where the entire formula is MIN(0).

We will now rebuild the bar chart from above, but instead of placing the Sales and Profit Ratio measures on the Columns Shelf, we will place this newly created Placeholder field on the Columns Shelf. Note that the dimensions on the Rows Shelf will stay the same, but the Placeholder field will be placed on the Columns Shelf four times; the first two will eventually be the dimensions that we are adding a tooltip to, and the second two will eventually be the Sales and Profit Ratio measures.

At this point we have the framework for our bar chart. What’s powerful about this second approach to creating the bar chart, and will provide the flexibility to add a tooltip to a dimension, is that each column now has its own set of Marks Cards. This means that they can be edited independently of each other.

I’ll start recreating the bar chart above by navigating to the third and fourth Marks Shelves, changing the mark type to Gantt Bar, and placing the Sales and Profit Ratio on the Size Marks Card for each respective Marks Shelf.

Here’s where the trick for adding a tooltip to a dimension comes in. For the first two Marks Shelves, I’ll change the Mark Type to Text and place the Segment and Ship Mode Dimensions on the Text Marks Card for each respective Marks Shelf.

Now that the dimensions are on the view as measures (because they are technically the text being displayed for the Placeholder measure), they have a complete set of Marks Cards. That means you can now add a tooltip to a dimension by modifying the Tooltip Marks Card! The tooltip can be used to show the definition of the measure, what data source it comes from, whether the data source is verified, additional context about the visualization, or whatever other purpose you can think of.

I’ll finish the view by cleaning up the formatting including:

– Hiding the first two columns (the original dimensions on the Rows Shelf) by right-clicking on them and deselecting “Show Header”.
– Getting rid of the zero lines and gridlines on the text columns by right-clicking on either column, choosing “Format…”, navigating to the Lines tab, and turning the zero lines and gridlines to none.
– Hide the Placeholder axes by right-clicking on any of the axes and deselecting “Show Header”. Note that this is one drawback to the Placeholder approach; you have to float the column headers and/or axes on a dashboard if you want them.

Lastly, if you’re losing sleep because the segment names are repeated for each row in the first column, there’s a hack for that too. You can color the text on the first row and color the remaining rows white using a simple table calculation.

First, make a calculated field with the formula “INDEX() = 1”. Next, put the newly created First Row calculation on the Color Marks Card for the first column. Change the direction and scope of the table calculation for the First Row calculated field to Pane (down). Give the first row color and change the color for the other rows to white.

Thanks for reading,
– Ryan