Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Show Percentage Change in Tableau

Cody Schneider••7 min read

Tracking performance over time is fundamental to understanding your business, but just looking at raw numbers can be misleading. Seeing a chart of your monthly website traffic is great, but knowing whether that traffic grew by 2% or 20% compared to the previous month is where the real insight lives. This article will show you exactly how to calculate and visualize percentage change in Tableau, from the straightforward Quick Table Calculation to more flexible custom formulas.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Why Is Percentage Change So Important?

Before jumping into the "how," let's briefly touch on the "why." Percentage change is a normalized metric that provides critical context. It helps you answer essential business questions like:

  • Performance Tracking: How did our sales this quarter compare to last quarter? Did our recent marketing campaign actually increase lead volume month-over-month?
  • Trend Identification: Is our user engagement growing steadily, or is growth slowing down? Are there seasonal dips or spikes we should be aware of?
  • Goal Setting and Measurement: If our goal is to increase revenue by 15% year-over-year, are we on track?

Calculating percent change turns raw data into actionable intelligence. Fortunately, Tableau makes this process painless once you know the steps.

Method 1: The Quickest Way with a Table Calculation

For most day-to-day analyses, Tableau's built-in "Quick Table Calculation" is your best friend. It’s fast, requires no code, and works perfectly for simple comparisons like month-over-month or quarter-over-quarter change.

Let's use the sample "Superstore" dataset that comes with Tableau to find the month-over-month (MoM) percentage change in sales.

Step 1: Build Your Initial View

First, we need a basic time-series chart showing sales over time.

  1. Drag Order Date onto the Columns shelf. Right-click the pill and make sure it's set to Month (you can choose the option that looks like "MONTH(Order Date)" for a continuous line).
  2. Drag Sales onto the Rows shelf.

You should now have a simple line chart showing total sales for each month.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Step 2: Apply the Percent Difference Calculation

Now, let's add the percentage change calculation.

  1. Drag the Sales measure onto the Rows shelf again, so you have two SUM(Sales) pills and two identical line charts.
  2. Right-click the second SUM(Sales) pill on the Rows shelf.
  3. In the menu that appears, navigate to Quick Table Calculation > Percent Difference.

The second line chart will instantly transform to show the percentage change from the previous month. You'll notice the very first month is blank — this is correct, as there's no prior month to compare it to.

Step 3: Create a Combination Chart for Better Visualization

Having two separate charts isn't ideal. Let's combine them into a single, easy-to-read view.

  1. Right-click the second pill on your Rows shelf (the one with the percent change calculation) and select Dual Axis.
  2. Tableau will overlay the two charts. On the Marks card, change the original SUM(Sales) mark type to Bar and the Percent Difference in Sales mark type to Line or Circle. This creates a much clearer visual distinction.
  3. Finally, right-click one of the y-axes and select Synchronize Axis to make sure they are aligned (this might be greyed out if your data types aren't similar, which is fine here).

You now have a clean bar chart showing monthly sales, with a line or series of circles highlighting the month-over-month growth or decline. This visual combo is incredibly effective for telling the story of your data at a glance.

Method 2: Gaining More Control with a Custom Formula

Quick Table Calculations are great, but sometimes you need more flexibility. Creating a custom "Calculated Field" lets you reuse the formula across multiple worksheets, give it a clear name, and adjust it for more complex scenarios, like year-over-year growth.

The standard formula for percentage change is:

(Current Period Value - Previous Period Value) / Previous Period Value

In Tableau, we use the LOOKUP() function to grab that "Previous Period Value."

Step 1: Create the Calculated Field

  1. Click the dropdown arrow at the top of the Data pane and select Create Calculated Field.
  2. Name your calculation something intuitive, like "MoM Sales % Change".
  3. Enter the following formula into the expression editor:

(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))

Formula Breakdown:

  • SUM([Sales]): This is the value for the current period (the current month in our chart).
  • LOOKUP(SUM([Sales]), -1): This "looks up" the value of SUM(Sales) from the partition that is one step before the current one (-1).
  • ZN(): Stands for "Zero Null." Wraps values to convert any NULL results into 0, preventing calculation failures if a period has no sales.
  • ABS(): Uses the absolute value of the denominator to ensure that negative previous period sales don't produce a strange result.
GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Step 2: Use the New Calculation in Your View

Once you save the calculated field, it will appear in your Data pane. You can drag "MoM Sales % Change" onto the Rows shelf, Color, or Tooltips on the Marks card.

IMPORTANT: When you use a calculated field that contains a table calculation like LOOKUP(), you still have to tell Tableau how to compute it.

  1. Drag your new calculated field onto your view.
  2. Right-click the pill and select Compute Using > Table (across). This tells Tableau to perform the calculation across the time axis.
  3. Right-click the pill again and select Format.... In the formatting pane, choose Pane > Numbers > Percentage to display it correctly.

How to Calculate Year-over-Year (YoY) Growth

This is where custom formulas really shine. Calculating year-over-year (YoY) growth is a common business request, and it's a simple tweak to the formula we just created.

To compare a month to the same month in the prior year, instead of looking back one position (-1), look back twelve positions (-12).

Create a new calculated field named "YoY Sales % Change" with this formula:

(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -12)) / ABS(LOOKUP(ZN(SUM([Sales])), -12))

That's the only change! Drag this new field into your view, set it to compute using Table (across), and format it as a percentage. Now you can see, for example, how November 2023 sales performed compared to November 2022.

Common Challenges and Best Practices

1. Handling the First Null Value

Remember that the first value in your time series will always be null because there's no data preceding it. This is expected and accurate. If you want to hide it, you don't have to create a complex formula. Simply right-click the null indicator in the bottom corner of your chart and select Filter Data.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

2. The "Compute Using" Setting is Everything

The most common reason a table calculation doesn't work is an incorrect "Compute Using" setting. If your chart isn't showing what you expect, right-click the calculation pill and experiment with the options. For a simple chart with time on the x-axis, Table (across) is almost always what you need. If your table is structured differently, you might need Table (down) or a specific dimension.

3. Make Your Visuals Clear

How you display the percentage change is just as important as the calculation itself.

  • KPI Cards: For dashboards, you might show just the most recent period's percentage change as a big, bold number. You can even add an up or down arrow using another calculated field like: IF [MoM Sales % Change] > 0 THEN "▲" ELSE "▼" END.
  • Use Color: Drag your percentage change calculation onto the Color mark. Then, edit the colors to use a diverging palette (like red-white-green). This instantly draws your audience's eye to periods of strong growth or steep decline.

Final Thoughts

Calculating percentage change is a core skill for anyone working with data in Tableau. Whether you use the lightning-fast Quick Table Calculation for simple MoM analysis or a custom LOOKUP() formula for more controlled calculations like YoY growth, you now have the tools to add much-needed context to your reports and dashboards.

While mastering these functions in a tool like Tableau is incredibly rewarding, we know that sometimes you need answers without having to stop and build the perfect visualization. We built Graphed for precisely those moments. Instead of dragging pills and writing formulas, you can connect data sources like Google Analytics or Shopify and simply ask, "Show me the year-over-year change in our total revenue as a bar chart." We create the dashboard for you in seconds, with live data, so you can spend less time configuring views and more time making decisions.

Related Articles