Mark types (automatic, bar, line, circle) in Tableau - Dashboard Guide

Dashboard Mode - Mark types (automatic, bar, line, circle)

Dashboard Goal

Understand how different mark types (automatic, bar, line, circle) display sales data trends and comparisons in Tableau.

Sample Data

Month	Product	Sales
Jan	Apples	100
Feb	Apples	150
Mar	Apples	130
Jan	Oranges	90
Feb	Oranges	120
Mar	Oranges	140

Dashboard Components

• KPI Card: Total Sales calculated as SUM([Sales]) = 730
• Bar Chart: Sales by Product for each Month using Marks Type = Bar. Shows side-by-side bars for Apples and Oranges per month.
• Line Chart: Sales trend over Months for each Product using Marks Type = Line. Lines connect sales points for Apples and Oranges.
• Circle Chart: Sales by Month using Marks Type = Circle. Circle size represents sales amount per month (combined products).
• Automatic Mark: Tableau chooses mark type based on fields. For example, when Month and Sales are used without specifying mark, Tableau picks the best mark automatically.

Dashboard Layout

+----------------------+-----------------------+
|      KPI Card        |      Bar Chart        |
|  (Total Sales = 730) | (Sales by Product)    |
+----------------------+-----------------------+
|      Line Chart      |      Circle Chart      |
| (Sales Trend)        | (Sales by Month Size) |
+----------------------+-----------------------+

Interactivity

Applying a filter on Product updates all charts and KPI card to show data only for the selected product(s). For example, selecting 'Apples' filters the bar, line, and circle charts and updates total sales accordingly.

Self Check

If you add a filter for Month = Feb, which components update and what changes occur?

• All components update to show only February data.
• KPI Card shows total sales for Feb (Apples 150 + Oranges 120 = 270).
• Bar Chart shows bars for Apples and Oranges in Feb only.
• Line Chart shows points only for Feb, breaking the trend lines.
• Circle Chart shows circle sized for total Feb sales (270).

Key Result

Dashboard showing sales data with different Tableau mark types: automatic, bar, line, and circle to compare and trend products over months.

Practice

1. In Tableau, what does the Automatic mark type do?

easy

A. It converts all data points into circles.

B. It always shows data as bars regardless of data type.

C. It lets Tableau choose the best mark type based on the data.

D. It forces the data to be displayed as a line chart.

Solution

1. Step 1: Understand the Automatic mark type purpose

   The Automatic mark type allows Tableau to decide the best way to show data visually based on the data's structure and fields used.

2. Step 2: Compare with fixed mark types

   Unlike fixed types like Bar, Line, or Circle, Automatic adapts to the data, choosing the most suitable mark type automatically.

3. Final Answer:

   It lets Tableau choose the best mark type based on the data. -> Option C

4. Quick Check:

   Automatic = Tableau chooses mark type [OK]

Hint: Automatic means Tableau picks the best mark type for you [OK]

Common Mistakes:

• Thinking Automatic always shows bars
• Confusing Automatic with a fixed mark type
• Assuming Automatic forces circles or lines

2. Which of the following is the correct way to set a mark type to Bar in Tableau?

easy

A. Drag a measure to Rows and select 'Circle' from the Marks card.

B. Double-click the data field and Tableau sets it to Automatic.

C. Right-click the axis and select 'Line'.

D. Click the Marks card dropdown and choose 'Bar'.

Solution

1. Step 1: Locate the Marks card in Tableau

   The Marks card controls how data is visually represented. To change mark type, you use the dropdown on this card.

2. Step 2: Select the Bar mark type

   Clicking the dropdown and choosing 'Bar' sets the visualization to bar marks.

3. Final Answer:

   Click the Marks card dropdown and choose 'Bar'. -> Option D

4. Quick Check:

   Marks card dropdown -> Bar [OK]

Hint: Use Marks card dropdown to pick Bar mark type [OK]

Common Mistakes:

• Selecting Circle instead of Bar
• Right-clicking axis to change mark type (wrong place)
• Assuming double-click sets Bar automatically

3. Given a time series data with dates on Columns and sales on Rows, which mark type will Tableau choose automatically to best show trends?

medium

A. Line

B. Bar

C. Circle

D. Automatic will always choose Pie

Solution

1. Step 1: Understand data type and visualization goal

   Time series data with dates and sales is best shown as a trend over time, which is usually a line chart.

2. Step 2: Know Tableau's Automatic behavior

   Tableau's Automatic mark type detects time series and picks Line marks to show trends clearly.

3. Final Answer:

   Line -> Option A

4. Quick Check:

   Time series + Automatic = Line [OK]

Hint: Automatic picks Line for time series trends [OK]

Common Mistakes:

• Choosing Circle for trend data
• Thinking Bar is default for time series
• Assuming Automatic picks Pie charts

4. You set the mark type to Line but your visualization shows disconnected points instead of a continuous line. What is the most likely cause?

medium

A. The date field is treated as a string, not a date.

B. You forgot to select Circle mark type.

C. The measure is on Columns instead of Rows.

D. Automatic mark type was selected instead of Line.

Solution

1. Step 1: Check data type of the date field

   If the date is treated as text (string), Tableau cannot connect points in order, so lines appear disconnected.

2. Step 2: Understand effect on line marks

   Line marks require a continuous axis like dates. Strings break continuity, causing points to show separately.

3. Final Answer:

   The date field is treated as a string, not a date. -> Option A

4. Quick Check:

   Disconnected lines = date as string [OK]

Hint: Ensure date fields are date type for continuous lines [OK]

Common Mistakes:

• Switching to Circle mark type unnecessarily
• Thinking measure placement causes disconnected lines
• Assuming Automatic mark type causes this issue

5. You want to compare sales amounts across product categories using a clear visual. Which mark type should you choose and why?

hard

A. Line, because it shows trends over categories.

B. Bar, because it compares quantities across categories clearly.

C. Circle, because it highlights individual data points.

D. Automatic, because it always picks Circle for categories.

Solution

1. Step 1: Identify the data and comparison goal

   Comparing sales amounts across categories is about comparing quantities side by side.

2. Step 2: Choose the best mark type for comparison

   Bar charts are best for comparing amounts across categories because bars show length differences clearly.

3. Step 3: Understand why other marks are less suitable

   Line marks show trends over time, circles highlight points but don't compare sizes well, Automatic may not pick Bar.

4. Final Answer:

   Bar, because it compares quantities across categories clearly. -> Option B

5. Quick Check:

   Category comparison = Bar chart [OK]

Hint: Use Bar marks to compare amounts across categories [OK]

Common Mistakes:

• Using Line marks for category comparison
• Choosing Circle marks for quantity comparison
• Relying on Automatic without checking mark type