Custom Number Formatting in Tableau

Overview

Tableau custom number formatting lets you control exactly how a field’s values appear in every worksheet without writing any calculated fields. Instead of transforming the data, you define a display‑only formatting pattern that Tableau applies consistently wherever that field is used. This includes specifying decimal precision, thousands separators, scaling (K, M, B), prefixes or suffixes, and even literal text. Because it’s set at the field level, it ensures uniform presentation across sheets, dashboards, and tooltips, making it ideal for KPIs, financial metrics, and standardized reporting.

These custom formats can include separate rules for positive, negative, and zero values using semicolon‑separated sections. Tableau supports symbols like # for optional digits, 0 for required digits, commas for scaling, and quoted text for labels. With these elements, you can create formats such as showing negatives in brackets, replacing zeros with a dash, or appending units like “kg” or “hrs.” Resulting to cleaner, more professional numeric displays without extra calculations or duplicated fields.

How to Access Tableau’s Custom Number Formatting

To access Tableau’s custom number formatting.

• Right-click the field of interest on the data pane.

• Under Default properties choose Number Format…

On the pop-up dialogue box.

• Select Custom

• Enter your custom formula in the Format section.

Below, find some of the formats you can use to custom format numbers in Tableau.

8 Ways You Can Format Numbers in Tableau

1. Thousands separator

Format: #,##0

Result: 2300000 becomes 2,300,000

2. KPI

Format: ▲#,##0;▼#,##0;0

Result: +10 becomes ▲10, -10 becomes ▼10, 0 stays 0.

3. Replace zero with a dash

Format: #,##0;-#,##0;-

Result: Replaces 0 with a dash. Good when dealing with text-heavy tables.

4. Format percentages

Format: +0.0%;-0.0%;0.0%

Result: Adds a + on positives, - on negatives, flat 0.0% on zero.

5. Hide negative values

Format: #,##0; ;0

Result: Shows positives and zeros, hides negatives.

6. Replace numbers with words

Format: "Positive";"Negative";"Zero"

Result: 40 becomes “Positive”, -30 becomes “Negative”, 0 becomes “Zero”

7. Number format with currency symbol

Format: £#,##0 ; (£#,##0) ; –

Result: 1200 becomes £1,200, -1500 becomes (£1,500), and 0 becomes -

8. Scaling large numbers (thousands, millions, and billions)

Format: #,##0,"K"

Result: 1300 becomes 1.3K

Format: #,##0,,"M"

Result: 1300000 becomes 1.3M

Format: #,##0,,,"B"

Result: 1300000000 becomes 1.3B

Conclusion

Custom number formatting in Tableau may seem like a small feature, but it has an outsized impact on the clarity and professionalism of your dashboards. By defining consistent, field‑level formatting rules, you ensure that every worksheet, tooltip, and KPI displays numbers exactly the way your audience expects - without extra calculations or repetitive manual adjustments. This not only improves readability but also strengthens the overall visual coherence of your analytics products.

Whether you’re standardizing financial metrics, simplifying operational reports, or adding business‑friendly labels, custom formats give you precise control over how data is presented. Mastering this capability helps you deliver dashboards that feel polished, intentional, and aligned with stakeholder expectations - making your Tableau work both more efficient and more impactful.

If you like the work we do and would like to work with us, drop us an email on our contacts page and we’ll reach out!

Thank you for reading!!