Difference and percent difference in Tableau - Step-by-Step Guide

Introduction

This feature helps you compare values by showing how much one number changes from another. It calculates the difference and the percent difference, making it easy to see growth or decline between data points.

When you want to see how sales this month compare to last month.

When you need to track the change in website visitors between two weeks.

When you want to analyze the increase or decrease in expenses year over year.

When you want to highlight the percentage change in customer satisfaction scores.

When you want to compare product performance between two regions.

Steps

Step 1: Open your Tableau workbook

- Tableau Desktop main window

Your data and worksheets are visible

Step 2: Drag the measure you want to analyze (e.g., Sales) to the Rows shelf

- Rows shelf

A chart or table showing the measure values appears

Step 3: Drag the dimension you want to compare by (e.g., Month) to the Columns shelf

- Columns shelf

Data is split by the chosen dimension, showing values side by side

Step 4: Right-click the measure on the Rows shelf and select 'Quick Table Calculation' > 'Difference'

- Measure pill on Rows shelf

The chart updates to show the difference between each data point and the previous one

Step 5: Right-click the measure again and select 'Quick Table Calculation' > 'Percent Difference'

- Measure pill on Rows shelf

The chart updates to show the percent difference between each data point and the previous one

Step 6: Click the measure pill, select 'Edit Table Calculation' to adjust calculation direction if needed

- Measure pill context menu

You can change how Tableau calculates difference (e.g., Table Across, Table Down)

Before vs After

Before

A bar chart shows monthly sales values: Jan $1000, Feb $1200, Mar $1100

After

After applying Difference, the chart shows: Feb $200, Mar -$100; after Percent Difference, it shows: Feb 20%, Mar -8.33%

Settings Reference

Quick Table Calculation Type

📍 Right-click measure pill > Quick Table Calculation

Choose the type of calculation to apply to your measure for comparison

Default: None

Edit Table Calculation

📍 Right-click measure pill > Edit Table Calculation

Control the direction and scope of the calculation to match your data layout

Default: Table Across

Common Mistakes

Applying difference calculation without setting the correct calculation direction

The difference may calculate across wrong dimension causing incorrect results

Use 'Edit Table Calculation' to set calculation direction matching your data layout

Confusing difference with percent difference

Difference shows absolute change, percent difference shows relative change; mixing them can mislead analysis

Choose the calculation type that fits your question: absolute change or relative change

Summary

Difference and percent difference help compare values between data points easily.

Use Quick Table Calculation to apply these comparisons quickly in Tableau.

Always check and adjust calculation direction to get accurate results.