Relative date filtering in Tableau - Step-by-Step Guide

Introduction

Relative date filtering lets you show data for a time period that moves with the current date. It helps you focus on recent or upcoming data without changing the filter every day.

When you want to see sales from the last 7 days and update automatically each day

When your dashboard should always show data for the current month without manual changes

When you want to compare this week’s performance to the same week last year

When you need to monitor data for the next 30 days to plan ahead

When you want to filter data to show only the last quarter dynamically

Steps

Step 1: Click

- Filters shelf on the date field

The Filter Field dialog opens showing filter options for the date

💡 Make sure your date field is recognized as a date type

Step 2: Select

- Relative Date option in the Filter Field dialog

The relative date filter options appear for you to choose a time range

Step 3: Choose

- Relative date filter options

You can pick options like last N days, this month, next N weeks, or last quarter

💡 Use the calendar icon to pick exact start or end dates if needed

Step 4: Set

- Number of periods and period type (days, weeks, months, quarters, years)

The filter updates to show data only for the selected relative time frame

Step 5: Click

- OK button

The filter applies and the view updates to show data for the relative date range

Before vs After

Before

The view shows all sales data from 2019 to 2024

After

The view shows only sales data from the last 30 days relative to today

Settings Reference

Relative Date Filter Type

📍 Filter Field dialog after selecting Relative Date

Defines whether to show past, current, or future periods relative to today

Default: Last

Period Type

📍 Relative Date filter options

Sets the unit of time for the relative filter

Default: Days

Number of Periods

📍 Relative Date filter options

Specifies how many periods to include in the filter

Default: 1

Common Mistakes

Choosing a fixed date filter instead of relative date

Fixed date filters do not update automatically, so the data becomes outdated

Use relative date filtering to keep the data range dynamic and current

Selecting the wrong period type (e.g., weeks instead of days)

This causes the filter to show a different time range than intended

Double-check the period type matches your analysis needs

Summary

Relative date filtering shows data for time periods that move with the current date.

It helps keep dashboards up-to-date without manual filter changes.

Remember to pick the right period type and number of periods for accurate results.