Tooltip customization in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants an interactive sales dashboard where users can hover over data points to see detailed sales information in a clear and helpful tooltip.

📊 Data: You have monthly sales data by product category and region, including sales amount, units sold, and profit margin.

🎯 Deliverable: Create a sales dashboard with a line chart showing monthly sales trends by category. Customize the tooltip to show sales amount, units sold, and profit margin with clear labels and formatting.

Sample Data

Month	Category	Region	Sales Amount	Units Sold	Profit Margin (%)
Jan	Electronics	North	12000	150	20
Jan	Furniture	North	8000	100	25
Feb	Electronics	South	15000	180	22
Feb	Furniture	South	7000	90	24
Mar	Electronics	East	13000	160	21
Mar	Furniture	East	9000	110	26
Apr	Electronics	West	14000	170	23
Apr	Furniture	West	8500	95	27

1

Step 1: Connect to the sales data source in Tableau and load the data.

No formula needed; just connect and import the data.

Expected Result

Sales data is loaded and visible in Tableau's Data pane.

2

Step 2: Create a line chart with Month on Columns, Sales Amount on Rows, and Category on Color.

Drag 'Month' to Columns, 'Sales Amount' to Rows, and 'Category' to Color on the Marks card.

Expected Result

Line chart shows monthly sales trends for each product category with different colors.

3

Step 3: Customize the tooltip to show Sales Amount, Units Sold, and Profit Margin with clear labels and formatting.

Click Tooltip on Marks card and edit text to: "<strong>Month:</strong> {{Month}} <strong>Category:</strong> {{Category}} <strong>Sales Amount:</strong> ${{SUM([Sales Amount])}} <strong>Units Sold:</strong> {{SUM([Units Sold])}} <strong>Profit Margin:</strong> {{AVG([Profit Margin (%)])}}%"

Expected Result

Tooltip shows all requested details clearly when hovering over any data point.

4

Step 4: Format the Sales Amount as currency and Profit Margin as percentage in the tooltip.

Use Tableau's formatting options in the tooltip editor to format Sales Amount with dollar sign and commas, and Profit Margin with percent sign and one decimal place.

Expected Result

Tooltip displays Sales Amount like $12,000 and Profit Margin like 20.0%.

5

Step 5: Test the tooltip by hovering over different points on the line chart to ensure all information appears correctly.

No formula; just interact with the visualization.

Expected Result

Tooltip appears with correct, formatted details for each data point.

Final Result

Monthly Sales Trends by Category

Month -> Jan  Feb  Mar  Apr

Electronics  |----|----|----|----|
Furniture    |----|----|----|----|

Tooltip Example when hovering on Electronics in Jan:
---------------------------------------------
Month: Jan
Category: Electronics
Sales Amount: $12,000
Units Sold: 150
Profit Margin: 20.0%
---------------------------------------------

✓Electronics consistently have higher sales than Furniture each month.

✓Profit margins are stable around 20-27% across categories and regions.

✓Tooltip customization helps users quickly see detailed sales info without cluttering the chart.

Bonus Challenge

Add dynamic tooltips that also show the percentage change in Sales Amount compared to the previous month for the same category.

Show Hint

Create a calculated field for percentage change using Tableau's LOOKUP function and include it in the tooltip with clear labels.