Continuous vs discrete dates in Tableau - Compared

Introduction

This feature helps you show dates in two ways: continuous or discrete. Continuous dates create a smooth timeline, while discrete dates show separate date parts like months or years. This helps you choose how to best display time data in your charts.

When you want to show sales over time as a smooth line without gaps

When you need to compare data by separate months or years as distinct columns

When your dashboard requires a timeline that automatically adjusts to date ranges

When you want to group data by exact date parts like quarters or weekdays

When you want to create a bar chart with each month as a separate bar

Steps

Step 1: Drag the date field to Columns or Rows shelf

- Data pane and Columns or Rows shelf

Tableau adds the date field to the view and shows a default date type

💡 Look at the pill color: blue means discrete, green means continuous

Step 2: Click the date field pill on the shelf

- Columns or Rows shelf

A menu appears with options for date parts and date values

Step 3: Select 'Exact Date' or 'Continuous' to use continuous dates

- Date field pill menu

The pill turns green and the axis shows a continuous timeline with no gaps

Step 4: Select a date part like 'Month', 'Year', or 'Quarter' to use discrete dates

- Date field pill menu

The pill turns blue and the view shows separate headers or bars for each date part

Step 5: Observe the axis or headers to confirm the date type

- View area

Continuous dates show a smooth axis; discrete dates show distinct labels or headers

Before vs After

Before

Date field pill is blue and shows separate months as column headers with gaps between bars

After

Date field pill is green and shows a smooth timeline axis with bars connected continuously

Settings Reference

Date field type

📍 Date field pill menu on Columns or Rows shelf

Choose how Tableau treats the date field for visualization

Default: Discrete Year or Month depending on data

Pill color

📍 Columns or Rows shelf

Visual indicator of date type in the view

Default: Blue for discrete dates

Common Mistakes

Using discrete dates when a continuous timeline is needed

This causes gaps and breaks in the timeline, making trends harder to see

Switch the date field to continuous by selecting 'Exact Date' or 'Continuous' in the pill menu

Confusing pill colors and not checking date type

You might think the dates are continuous but they are discrete, affecting chart appearance

Always check the pill color: green means continuous, blue means discrete

Summary

Continuous dates create smooth timelines with no gaps and use a green pill color

Discrete dates show separate date parts like months or years with a blue pill color

Choose date type based on whether you want a timeline or grouped date categories