Date filters in Tableau - Step-by-Step Guide

Introduction

Date filters let you show only data from certain dates in your Tableau view. This helps focus on specific time periods, like last month or this year, without changing the original data.

When you want to see sales only from the last 30 days on your dashboard

When your report needs to compare this year’s data to last year’s data

When you want to analyze customer activity during a specific event date range

When you want to exclude future dates from your analysis

When you want to create a filter that lets users pick any date range interactively

Steps

Step 1: Open your Tableau workbook

- Tableau Desktop main window

Your data and sheets are visible ready for editing

Step 2: Drag your date field from the Data pane

- Data pane on the left

Date field appears on Filters shelf

💡 Date fields usually have a calendar icon

Step 3: In the Filter Field dialog, select the filter type

- Filter Field dialog box

Options like Range of dates, Relative dates, or Individual dates appear

Step 4: Choose 'Range of dates' and click OK

- Filter Field dialog box

A calendar appears to pick start and end dates

Step 5: Select the start and end dates for your filter

- Calendar in Filter dialog

Only data within these dates will show in your view

Step 6: Click OK to apply the filter

- Filter dialog box

Your worksheet updates to show data only for the selected date range

Step 7: Show the filter control on the worksheet

- Filters shelf, right-click the date filter

A filter card appears on the right side allowing interactive date changes

💡 Users can now pick different dates without editing the filter

Before vs After

Before

Worksheet shows all sales data from 2018 to 2024

After

Worksheet shows only sales data from January 1, 2023 to March 31, 2023

Settings Reference

Filter Type

📍 Filter Field dialog after dragging date to Filters shelf

Choose how you want to filter dates: by a fixed range, relative to today, or specific dates

Default: Range of dates

Show Filter

📍 Filters shelf, right-click date filter

Display a filter control on the worksheet for user interaction

Default: Hide Filter

Relative Date Options

📍 Filter Field dialog when 'Relative dates' is selected

Filter data relative to the current date dynamically

Default: Today

Common Mistakes

Choosing 'Individual dates' when you want a continuous range

This shows only specific single dates, not a range, so data outside those dates is excluded

Use 'Range of dates' filter to include all dates between start and end

Not showing the filter control after applying the filter

Users cannot change the date filter interactively without the filter card visible

Right-click the date filter on Filters shelf and select 'Show Filter' to enable user control

Summary

Date filters let you focus your Tableau views on specific time periods easily.

You can pick fixed date ranges or dynamic relative dates like 'last 7 days'.

Remember to show the filter control if you want users to change dates interactively.