What If Tableau?

Ever find yourself staring at a sales chart and thinking, "What would happen if we increased our ad spend by another 10%?" or "How would a 5% discount impact our total revenue next quarter?" This kind of forward-looking analysis, often called "what-if" or scenario modeling, is where data stops being just a record of the past and becomes a tool for shaping the future. This guide walks you through how to build your own powerful what-if scenarios directly in Tableau, turning your dashboards into interactive planning tools.

Graphed

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.

Build Your First Agent

What is What-If Analysis, Anyway?

At its heart, what-if analysis is simply a way to see how changing one variable can affect others. Instead of reporting on fixed numbers from your database, you introduce a hypothetical change to see the potential outcome. It's the digital version of tweaking a knob to see how the machine changes its output.

From a business perspective, this is incredibly valuable for:

• Budgeting and Forecasting: See potential revenue growth based on different marketing budget allocations.
• Sales Strategy: Model the impact of various commission rates or quotas on your team's total earnings and company costs.
• Pricing Decisions: Test different discount levels to find the sweet spot between attracting customers and maintaining profitability.
• Operations Planning: Understand how staffing changes or efficiency gains could affect project timelines and costs.

Rather than making a "gut feeling" decision, what-if analysis lets you ground your strategy in data, exploring multiple outcomes before committing to a course of action.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

The Key Tool: Tableau Parameters

To perform what-if analysis in Tableau, your most important tool is the Parameter. If you're new to them, it's easy to get confused, so let's clear it up.

A Parameter is a workbook variable that you, or anyone viewing your dashboard, can control. Think of it as a user-controlled input field, like a slider, a dropdown list, or a text box. It's a placeholder value that doesn’t do anything on its own. Its power comes from being connected to your data through a calculated field.

Here’s the difference between a parameter and a simple filter:

• A filter hides or shows data that already exists. For example, filtering by "Region = West" simply removes all other regions from your view.
• A parameter provides a dynamic input that can change your data through calculations. It lets you create new values that don't exist in your original dataset, like a "Forecasted Sales" number.

Building Your First What-If Scenario: A Step-by-Step Guide

Let's get our hands dirty with a practical example. Imagine we're a SaaS company, and we want to create a what-if model to see how an increase in our website's conversion rate would impact our projected quarterly revenue.

Step 1: Create Your Parameter

First, we need to create the 'knob' our user will turn. This will be the parameter that controls our hypothetical conversion rate increase.

1. In the Data pane on the left side of your Tableau worksheet, click the small dropdown arrow at the top and select Create Parameter.
2. A new window will pop up. Let's configure it:
3. Click OK. You'll now see Conversion Rate Lift % in the Parameters section at the bottom of your Data pane.
4. Right-click on your new parameter and select Show Parameter. A slider control should appear on the right side of your worksheet. Try moving it — notice how nothing happens yet? That's our next step.

Graphed

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.

Build Your First Agent

Step 2: Create a Calculated Field to Use the Parameter

The parameter is just an input field. Now we need to tell Tableau how to use that input to change our data. We'll do this with a calculated field that creates our new "what-if" revenue forecast.

1. Click the same dropdown arrow in the Data pane and select Create Calculated Field.
2. Name this field something intuitive, like Projected Revenue.
3. Now for the formula. Let's assume you have a field called [Revenue] in your data. The logic is simple: take the current revenue and increase it by the percentage from our parameter.

Here's the formula to type into the calculation editor:

[Revenue] * (1 + [Conversion Rate Lift %])

Let's break that down:

• [Revenue] is your existing revenue measure.
• [Conversion Rate Lift %] is the parameter we just created. When you type it, Tableau should recognize and color-code it.
• Multiplying your revenue by (1 + [Parameter]) is the standard way to apply a percentage increase. For example, if the parameter is set to 0.10 (10%), this becomes [Revenue] * 1.10.

Click OK to save the calculated field. You'll see Projected Revenue appear in your Measures.

Step 3: Build the Visualization

Now, let's bring it all together and see our what-if scenario in action.

1. Build a simple chart showing revenue over time. Drag your date field (let's say Order Date) to the Columns shelf and your original Revenue measure to the Rows shelf. You should see a basic line or bar chart of your recent revenue.
2. Now, drag your new Projected Revenue calculated field to the Rows shelf, right next to the Revenue pill. Tableau will likely create two separate charts.
3. To make this more intuitive, right-click on the Projected Revenue pill in the Rows shelf and select Dual Axis. This overlays the two metrics on a single chart.
4. To make sure the axes are aligned, right-click on the right-hand axis (for Projected Revenue) and select Synchronize Axis.
5. You can even go to the Marks card to change the color or chart type for each measure to make them visually distinct (e.g., solid line for actual revenue, dashed line for projected revenue).

Now for the fun part! Go to your Conversion Rate Lift % parameter slider on the right. Slide it up and down. You should see the Projected Revenue line dynamically move up and down in real-time while the original Revenue line stays put. You've officially built an interactive what-if model!

More Practical Examples for Your Business

This same technique can be applied to almost any area of your business. Here are a few more quick ideas to get you thinking:

Example 1: Sales Quota Modeling

• Business Question: How would adjusting our sales quota affect our team's performance against their "percent-to-goal" target?
• Parameter: Create an integer parameter called Quarterly Sales Quota with a text input box.
• Calculated Field: Create a field named Percent to Goal with the formula SUM([Sales]) / [Quarterly Sales Quota].
• Visualization: A bar chart showing Percent to Goal for each sales rep. As you adjust the Quota parameter, you can instantly see who would be over or under target.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Example 2: Budget Impact Analysis

• Business Question: If we increase our marketing spend by X amount, what would happen to our cost per acquisition (CPA)?
• Parameter: A float parameter named Marketing Spend Increase formatted as a currency.
• Calculated Field: Create Projected CPA with the formula ([Original Spend] + [Marketing Spend Increase]) / [Number of Conversions].
• Visualization: A KPI box showing the Projected CPA that updates as you adjust the spending increase.

Example 3: Price Elasticity Scenario

• Business Question: How would a discount affect our total number of units sold and our overall revenue? (This requires making an assumption about elasticity.)
• Parameter: A float parameter named Price Discount % with a range from 0.0 to 0.3.
• Calculated Field 1 (Projected Units): [Units Sold] * (1 + ([Price Discount %] * 1.5)). (Here, we're assuming that for every 1% discount, unit sales increase by 1.5%. You'd adjust this "1.5" based on your business knowledge.)
• Calculated Field 2 (Projected Revenue): ([Original Price] * (1 - [Price Discount %])) * [Projected Units].
• Visualization: A dashboard with two charts: one showing the increase in units sold, another showing the net change in total revenue, both controlled by the single discount slider.

Final Thoughts

By connecting parameters with calculated fields, you can transform standard Tableau reports from static history lessons into dynamic sandboxes for future planning. These what-if models empower your teams to explore possibilities, test assumptions, and make data-driven decisions with far more confidence than relying on static spreadsheets alone.

Building these scenarios in Tableau is a powerful skill, but it comes with a definite learning curve. We created Graphed because we believe asking fundamental 'what-if' questions shouldn't require mastering a complex tool. Instead of manually creating parameters and debugging calculations, you can just ask in plain English, "Show me a forecast of my sales for next quarter if we increase ad spend by 20% on Facebook." We build the interactive dashboard for you instantly, connecting directly to your live data so you're always exploring with the latest numbers. It's a way to get straight to scenario planning without getting sidetracked by technical setup.