How to Make Negative Numbers Red in Tableau

Seeing red in your data reports isn't always a bad thing - especially when it immediately draws your attention to exactly what needs fixing. Coloring negative numbers is one of the quickest ways to make financial reports, performance dashboards, and variance analyses instantly understandable. This guide will walk you through several easy and powerful methods for making negative numbers red in Tableau, from a simple formatting trick to more flexible techniques for complex visuals.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Does Coloring Negative Numbers Even Matter?

In data visualization, our goal is to communicate information as quickly and clearly as possible. We use things like size, shape, and color to guide our audience's attention. These are called pre-attentive attributes because our brains process them in milliseconds, before we even consciously "read" the chart.

Color is one of the most powerful pre-attentive attributes. Think about it:

• Financial Statements: Red ink has been used to signify financial loss for centuries. Showing negative profit, budget variance, or sales growth in red leverages a universally understood convention, making your report instantly scannable.
• Performance Spotting: Are you looking at year-over-year growth for 50 different product categories? The ones colored red will immediately jump out as areas of concern, saving you the mental effort of scanning each number and checking for a minus sign.
• Error Detection: If a certain metric should never be negative (like inventory counts or website sessions), coloring negatives in red acts as an immediate data quality alert.

By applying a simple color rule, you transform a plain table of numbers into a strategic tool that directs focus and accelerates decision-making. Now, let's explore how to actually do it in Tableau.

Method 1: The Quickest Fix with Custom Number Formatting

For text tables, crosstabs, and labels, the fastest way to make negative numbers red is by using Tableau’s custom number formatting. This method doesn't require any calculations and can be done in under 30 seconds.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step-by-Step Instructions:

1. Right-click the measure you want to format in your view. For example, if you have SUM(Profit) on the Text mark, right-click that green pill.
2. From the context menu, select Format.... This will open the Format pane on the left side of your screen.
3. In the Format pane, make sure you are on the "Pane" tab (or "Header" if you're formatting an axis).
4. Under the "Numbers" dropdown, select Custom.
5. A text box will appear. This is where you'll enter a special formatting code.

The format is divided into three parts, separated by semicolons: Positive Numbers,Negative Numbers,Zero.

Here’s how to use it. In the custom format box, you could type:

#,##0,[Red]-#,##0,0

Let's break that down:

• #,##0: This part formats positive numbers with a comma for thousands but no decimal places.
• [Red]-#,##0: This is the important part. It tells Tableau to format negative numbers with a preceding minus sign and to color them red.
• 0: This tells Tableau to simply show the number zero for values that are exactly zero.

Common Custom Format Variations:

You can tweak the format code to fit accounting standards or your personal preferences. Here are a few popular options:

• For showing decimals and parenthesis for negatives:
• For currency ($USD):
• For percentages:

Pros of this method: It’s incredibly fast, intuitive, and perfect for simple text-based visualizations. Cons of this method: It only formats the number text itself. It cannot be used to color the background of a cell, a bar in a bar chart, or a country on a map. For that, we need a more flexible approach.

Method 2: Gaining More Flexibility with a Calculated Field

When you want to control the color of the mark itself (like a bar, a circle, or the background of a table cell), a calculated field is the way to go. This approach involves creating a new field that categorizes your numbers as "Positive" or "Negative," which you can then drop onto the Color mark.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 1: Create the 'Color' Calculated Field

1. Click the dropdown arrow at the top of the Data pane (on the upper left) and select Create Calculated Field.
2. Name your new field something descriptive, like Profit Color.
3. In the formula box, type the following logic:

IF SUM([Profit]) < 0 THEN "Negative" ELSE "Positive" END

This formula checks each value of your Profit measure. If it's less than zero, it assigns the string "Negative", otherwise, it assigns "Positive". Click OK to save the calculation. You'll now see Profit Color in your data pane.

Tip: You can get even more specific. For example, if you wanted to isolate zero, you could use an IF/ELSEIF statement: IF SUM([Profit]) < 0 THEN "Negative" ELSEIF SUM([Profit]) > 0 THEN "Positive" ELSE "Zero" END.

Step 2: Apply the Calculation to Your Chart

1. Drag your new calculated field (Profit Color) from the Data pane directly onto the Color mark on the Marks card.
2. Tableau will instantly apply default colors to your chart based on whether the value is positive or negative. For a text table, the numbers themselves will change color. For a bar chart, the bars will change color.
3. To customize the colors, click the Color mark, then click Edit Colors....
4. In the dialog box, select "Negative" from the list and choose a shade of red. Select "Positive" and choose a neutral color like black or gray. Click OK.

Now, your entire mark is colored, not just the text. You can use this method to create bar charts with red and black bars, or highlight tables where the entire cell background turns red for negative values.

Pros of this method: Extremely versatile - it works for virtually any chart type in Tableau and gives you precise control over the colors and logic. Cons of this method: Requires creating an additional field, which adds a small layer of complexity compared to custom number formatting.

Method 3: Visual Highlighting with a Stepped Color Palette

This third method is a fantastic middle-ground, particularly for creating heatmaps or highlight tables where you want cell backgrounds to be colored based on their value. It's almost as fast as custom formatting but gives you a more visual result.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step-by-Step Instructions:

1. Create a view, such as a table of Profit by Sub-Category.
2. Instead of dragging SUM(Profit) to the Text mark, change the mark type on the Marks card dropdown from "Automatic" to "Square". This creates a heatmap cell for each value.
3. Now, drag SUM(Profit) onto the Color mark. Tableau will default to a continuous color gradient, usually from blue to orange.
4. Click on the Color mark, then Edit Colors...
5. From the "Palette" dropdown, choose a diverging palette that has red on one end, such as Red-Black Diverging or Red-Green Diverging.
6. Check the box for Stepped Color and set the number of steps to 2. This forces Tableau to only use two colors instead of a smooth gradient.
7. Click the Advanced >> button. Set the Center value to 0. This step is critical - it tells Tableau that zero is the dividing line in your color palette. Anything below zero will be red, and anything above will be your other chosen color (black or green).
8. Click OK. Your heatmap will now be perfectly colored, with all negative cells highlighted in red. You can still drag SUM(Profit) onto the Label mark if you want to see the numbers inside the colored squares.

Pros of this method: Visually powerful, excellent for dashboards, and very fast for standard positive/negative splits without creating a calculated field. Cons of this method: It works best for coloring the whole mark (like a bar or square) rather than just the text. Its purpose is primarily visual bucketing, not fine-grained text formatting.

Final Thoughts

Coloring negative numbers is a small change that delivers a big analytical impact. Whether you use the lightning-fast Custom Number Format for simple tables, a discrete Calculated Field for maximum chart flexibility, or a Stepped Color palette for creating powerful heatmaps, you're making your data easier to interpret at a glance.

Ultimately, these techniques are all about saving time and reducing friction between your data and the insight you need. We believe getting answers shouldn't require complex steps or remembering formatting codes. With Graphed, we apply these best practices automatically. You can connect your marketing and sales data and simply ask, "show me revenue by campaign, and highlight any with negative ROI in red," and our AI data analyst builds the report for you - no format panes, no calculated fields, just instant, clear visualizations.