Label display in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a clear sales dashboard that shows total sales by product category with labels on each bar for easy reading.

📊 Data: You have monthly sales data including Product Category, Sales Amount, and Month.

🎯 Deliverable: Create a bar chart showing total sales by product category with data labels displayed on each bar.

Sample Data

Product Category	Month	Sales Amount
Electronics	January	12000
Furniture	January	8000
Clothing	January	6000
Electronics	February	15000
Furniture	February	7000
Clothing	February	9000
Electronics	March	13000
Furniture	March	8500
Clothing	March	7000

1

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

No formula needed; just connect and load data.

Expected Result

Sales data with Product Category, Month, and Sales Amount is available in Tableau.

2

Step 2: Create a new worksheet and drag 'Product Category' to the Columns shelf.

Drag 'Product Category' field to Columns.

Expected Result

Columns shelf shows Product Category with distinct categories.

3

Step 3: Drag 'Sales Amount' to the Rows shelf and set aggregation to SUM.

SUM([Sales Amount]) on Rows shelf.

Expected Result

Bar chart with total sales amount for each product category.

4

Step 4: Add data labels to the bars by dragging 'SUM(Sales Amount)' to the Label mark.

Drag SUM([Sales Amount]) to Label on Marks card.

Expected Result

Each bar shows a label with the total sales amount.

5

Step 5: Format the labels for better readability: increase font size and set color to dark for contrast.

Format labels: Font size 12pt, Color black.

Expected Result

Labels are clear and easy to read on each bar.

6

Step 6: Add a chart title 'Total Sales by Product Category' and ensure the chart is accessible with proper color contrast.

Set worksheet title and check color contrast settings.

Expected Result

Chart has a clear title and meets accessibility standards.

Final Result

Total Sales by Product Category

| Electronics | ██████████████████ 40000 |
| Furniture   | ████████████ 23500 |
| Clothing    | █████████ 22000 |

Labels show exact sales amounts on each bar.

✓Electronics has the highest total sales across the three months.

✓Furniture and Clothing have similar but lower total sales.

✓Data labels make it easy to compare sales values directly on the chart.

Bonus Challenge

Add monthly sales trend lines for each product category with labels showing monthly sales values.

Show Hint

Use a line chart with 'Month' on Columns, 'SUM(Sales Amount)' on Rows, and 'Product Category' on Color. Add labels by dragging SUM(Sales Amount) to Label.

Practice

1. What is the primary purpose of adding labels to a chart in Tableau?

easy

A. To change the chart type

B. To filter data points

C. To display exact data values directly on the chart

D. To create a new data source

Solution

1. Step 1: Understand the role of labels in visualization

   Labels show exact values on charts, making data easier to interpret.

2. Step 2: Differentiate labels from other features

   Labels are not for filtering or changing chart types but for displaying values.

3. Final Answer:

   To display exact data values directly on the chart -> Option C

4. Quick Check:

   Labels = show exact values [OK]

Hint: Labels show exact numbers on charts, not filters or types [OK]

Common Mistakes:

• Confusing labels with filters
• Thinking labels change chart type
• Assuming labels create data sources

2. Which Tableau interface element do you use to add labels to marks on a chart?

easy

A. Data pane

B. Filters shelf

C. Pages shelf

D. Marks card

Solution

1. Step 1: Identify where labels are controlled in Tableau

   The Marks card controls how marks appear, including labels.

2. Step 2: Confirm other options do not add labels

   Filters shelf filters data, Pages shelf controls animation, Data pane shows fields.

3. Final Answer:

   Marks card -> Option D

4. Quick Check:

   Labels added via Marks card [OK]

Hint: Labels are on the Marks card, not Filters or Data pane [OK]

Common Mistakes:

• Trying to add labels via Filters shelf
• Looking for labels in Data pane
• Confusing Pages shelf with label controls

3. Given a bar chart with sales data, what happens if you check the 'Show Mark Labels' option on the Marks card?

medium

A. Sales values appear on each bar

B. Bars change color randomly

C. Chart switches to a line graph

D. Data filters to top 10 sales only

Solution

1. Step 1: Understand the effect of 'Show Mark Labels'

   Checking this option displays the data values on each mark (bar).

2. Step 2: Verify other options are unrelated

   Color changes, chart type switches, or filtering do not happen by enabling labels.

3. Final Answer:

   Sales values appear on each bar -> Option A

4. Quick Check:

   Show Mark Labels = display values [OK]

Hint: Show Mark Labels displays values on marks, no color or filter changes [OK]

Common Mistakes:

• Expecting color changes when enabling labels
• Thinking chart type changes automatically
• Assuming filtering happens with labels

4. You added labels to a scatter plot but they overlap and are hard to read. What is the best way to fix this issue in Tableau?

medium

A. Remove labels completely

B. Use the Label shelf to adjust alignment and font size

C. Increase font size and change label color

D. Switch to a pie chart

Solution

1. Step 1: Identify how to improve label readability

   Adjusting alignment and font size on the Label shelf helps reduce overlap and improve clarity.

2. Step 2: Evaluate other options

   Increasing font size may worsen overlap; removing labels loses info; switching chart changes visualization type unnecessarily.

3. Final Answer:

   Use the Label shelf to adjust alignment and font size -> Option B

4. Quick Check:

   Label shelf adjusts label display [OK]

Hint: Adjust label alignment and size on Label shelf to fix overlap [OK]

Common Mistakes:

• Increasing font size without alignment adjustment
• Removing labels instead of fixing them
• Changing chart type unnecessarily

5. You want to create a dashboard showing monthly sales with labels only on months where sales exceed 1000. How can you achieve this label display in Tableau?

hard

A. Use a calculated field to show labels conditionally and place it on Label shelf

B. Manually add labels to each month exceeding 1000

C. Filter data to only months with sales over 1000

D. Change the chart type to pie chart

Solution

1. Step 1: Create a calculated field for conditional labels

   Write a formula like IF SUM(Sales) > 1000 THEN STR(SUM(Sales)) ELSE "" END to show labels only when sales exceed 1000.

2. Step 2: Place the calculated field on the Label shelf

   This ensures only those months meeting the condition display labels, keeping others blank.

3. Final Answer:

   Use a calculated field to show labels conditionally and place it on Label shelf -> Option A

4. Quick Check:

   Conditional labels via calculated field [OK]

Hint: Use calculated field with IF condition on Label shelf for selective labels [OK]

Common Mistakes:

• Trying to add labels manually for each month
• Filtering data removes months instead of just hiding labels
• Changing chart type does not control label display