How to Show Negative Values in Tableau

Displaying negative numbers in Tableau should be simple, but it can quickly become frustrating when your bars look strange or your colors don’t make sense. Getting this right is crucial for accurately showing performance data like profit and loss, year-over-year changes, or budget variances. This guide walks you through several clear, practical methods to effectively visualize negative values in your Tableau dashboards, from simple color adjustments to more advanced custom charts.

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

Why Does Properly Visualizing Negative Values Matter?

Before jumping into the "how," it's important to understand the "why." How you display negative values can completely change the story your data tells. A bar chart that mixes positive profit and negative losses without a clear visual cue can mislead your audience into thinking every category is profitable. Correct visualization immediately separates the wins from the losses.

Think about these common scenarios:

• Profit and Loss Analysis: Instantly spotting which products, regions, or departments are losing money is fundamental. Obscuring losses slows down decision-making.
• Performance vs. Target: Are sales teams hitting their quota? Visualizing the variance - positive for exceeding targets and negative for falling short - gives a quick, clear health check.
• Change Over Time: Analyzing monthly growth rates means you'll have positive and negative values. Clear formatting is essential to distinguish periods of growth from periods of decline.

Getting it wrong isn't just a minor formatting error, it's a failure in data communication. The following methods will ensure your dashboards tell the right story, every time.

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

Method 1: Using Color to Differentiate Negative Values

The simplest and most effective way to distinguish positive from negative numbers is with color. Our brains are hardwired to associate certain colors with specific meanings, like red for a warning or loss and blue or green for positive outcomes. Tableau's default settings can sometimes be a bit clunky, but customizing them is easy.

Step-by-Step Instructions:

1. Drag Your Measure to Color: Start by building a simple bar chart. For this example, let's use Sub-Category on the Rows shelf and Profit on the Columns shelf. This will give you a standard bar chart.
2. Apply the Color Mark: Now, drag another copy of your Profit measure from the Measures pane directly onto the Color icon in the Marks card. By default, Tableau will apply a continuous color gradient (usually blue). Positive numbers will be a darker shade of blue, while negative numbers will be a lighter shade. This is better than nothing, but not ideal.
3. Edit the Color Palette: To fix this, click on the Color mark, then select "Edit Colors." This will open the color configuration window.
4. Center the Palette on Zero: This is the most important step. In the Edit Colors window, expand the "Advanced" options. Check the box that says "Stepped Color" and set the number of steps to 2. Then, set a checkmark on the "Center" option and enter the value 0. This tells Tableau to treat zero as the midpoint. Now, any value above zero will be one color (e.g., blue), and any value below zero will be the other color (e.g., red).

After following these steps, your bar chart will instantly communicate performance. Categories like "Tables" and "Bookcases," which are often unprofitable in the Superstore dataset, will immediately stand out in red, while profitable ones like "Copiers" and "Phones" will be shown in blue.

Method 2: Formatting Numbers to Clearly Display Negatives

While color is great for charts, what about showing the numbers themselves in a table, in a tooltip, or as labels? A negative sign (-) works, but some financial reports prefer using parentheses for negative values - for instance, displaying -$500 as ($500). This convention is cleaner and widely understood in business contexts.

Here's how to customize your number format:

Step-by-Step Instructions:

1. Right-Click a Measure: In your view (on a shelf or on the chart itself), right-click the measure pill you want to format (e.g., SUM(Profit)).
2. Select Format: From the context menu, choose "Format." This will open the Format pane on the left side of your workspace.
3. Choose Your Scope: In the Format pane, make sure you are on the correct tab - either "Axis" if you want to format the chart's axis or "Pane" if you want to format the numbers within the table or on the marks themselves.
4. Apply a Custom Format: Under the "Numbers" dropdown, select "Custom." This allows you to define exactly how your numbers should appear.

In the "Format" text box, you can enter a custom string. The format is structured as: Positive Numbers , Negative Numbers, Zero. Here are a couple of useful examples:

• For Parentheses: To show negative numbers in parentheses without decimal places, use: #,##0,(#,##0),0
• For Parentheses with Decimals: If you need two decimal places, use: #,##0.00,(#,##0.00),0.00
• Adding a Minus Sign Cleanly: While the default automatic format does this, custom formatting gives you more control. The standard format with commas would be: #,##0.00,-#,##0.00,0.00

This simple change enhances readability, especially in text-heavy tables, aligning your dashboards with standard financial reporting practices.

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

Method 3: Creating a Calculated Field for More Control

What if you want logic that goes beyond just color or number formatting? For example, you might want to create separate charts for profitable and unprofitable items or label them differently. Calculated fields give you this flexibility.

A simple calculated field can categorize your data, which you can then use to drive colors, filters, or labels.

Creating a "Profit Status" Calculated Field:

1. Navigate to the top menu and select "Analysis" > "Create Calculated Field."
2. Name your new field something descriptive, like "Profit Status."
3. In the formula box, enter the following logic: IF SUM([Profit]) >= 0 THEN "Profitable" ELSE "Unprofitable" END
4. Click "OK."

Now you have a new dimension in your data pane. You can drag "Profit Status" onto the Color mark instead of the SUM(Profit) measure. Tableau will assign a default color to "Profitable" and another to "Unprofitable," which you can then customize to your liking (e.g., Profitable = blue, Unprofitable = red). This method is cleaner and can be easier for other users to understand what the color legend means.

Method 4: Building a Diverging Bar Chart

A diverging bar chart is an excellent way to show both positive and negative values originating from a central baseline (zero). This design makes it incredibly easy to compare the scale of gains versus losses. In Tableau, this requires a slightly more advanced approach but delivers a professional, high-impact result.

Here’s a common way to build it:

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

Step-by-Step Instructions:

1. Create Two Calculated Fields: We need one field for positive values and another for negative values.
2. Build the Dual-Axis Chart:
3. Synchronize and Format the Axes:
4. Clean Up and Color:

The final result is a clean, intuitive chart showing positive bars extending to the right and negative bars extending to the left from a central zero-point, perfect for variance analysis.

Final Thoughts

Visualizing negative values in Tableau is a fundamental skill for creating reports that are both accurate and easy to understand. Whether you're using simple color-coding for quick analysis, custom number formats for professional tables, or building detailed diverging bar charts for impact, these techniques will help you tell a clearer story with your data.

Implementing these methods correctly takes a bit of practice, but it's time well spent. We've seen firsthand how teams can get caught up for hours tweaking chart settings instead of focusing on strategy. That's why we built tools that make this whole process simpler. With a tool like Graphed, you can connect your data and just ask in plain language, "show me profit vs. loss for each sub-category, with losses shown in red," and it builds the correct visualization for you in an instant, leaving you more time to act on the insights you discover.