How to Change Data Format in Tableau

Transforming a column of raw numbers into clear, readable information is one of the most fundamental tasks in data analysis. Whether you need to show 1500000 as $1.5M, 0.25 as 25%, or a list of dates in a consistent MM/DD/YYYY format, proper formatting makes your dashboards intuitive and professional. This guide will walk you through the various ways to change data formats in Tableau, from quick default changes to more advanced, custom solutions.

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

Understanding Data Types vs. Data Formats in Tableau

Before we get into the "how," it's helpful to understand the distinction between a data type and a data format. In Tableau, these two concepts work together but are not the same thing.

• Data Type: This is Tableau's internal classification of a field. It determines what kind of data is in the column (e.g., Number, String, Date, Boolean). Tableau usually assigns data types automatically when you connect to a source, but you can change it in the Data Source page or from the Data Pane. For instance, a field containing 123 is a Number data type.
• Data Format: This is purely about the display of the data. It's the presentation layer that tells Tableau how to show the information to the end-user. For that same field containing 123 (a Number data type), you can format it to be displayed as $123.00 (Currency), 123 (Standard Number), or even 12,300.00% (Percentage). The underlying data (123) doesn't change, only how it looks on your sheet.

In short, the data type is what the data is, and the data format is how it looks. Getting the format right is crucial for communicating insights clearly.

Method 1: Formatting from the Data Pane (Setting a Default)

The most straightforward way to format a field is by setting its default properties in the Data Pane on the left side of your workspace. Making a change here applies the format to the field everywhere you use it across the entire workbook. This is perfect for ensuring consistency, especially for key metrics like sales, profit ratio, or session counts.

Here’s how to do it step-by-step:

1. Find the field (measure or dimension) you want to format in the Data Pane.
2. Right-click on the field name.
3. In the context menu that appears, hover over Default Properties.
4. Select either Number Format... or Date Format... from the next menu, depending on your field.

This opens the Default Format dialog box, where you can choose from a wide range of presets and custom options.

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

Common Number Formats

When you select Number Format..., you'll see a list of common data types you can format as:

• Number (Standard): Your baseline, an unformatted number.
• Number (Custom): Lets you control decimal places, include thousand separators, and handle negative values. Great for custom numeric identifiers or values that don't fit other categories.
• Currency (Standard): Automatically formats the number using your computer's locale settings for currency (e.g., $ for the US).
• Currency (Custom): Gives you full control to change the currency symbol, add a prefix/suffix, choose the number of decimal places, and select display units (e.g., Thousands (K), Millions (M), Billions (B)).
• Percentage: Converts numbers into percentages (e.g., 0.75 becomes 75.00%) and allows you to set the decimal places.
• Scientific: Displays numbers in scientific notation.

Common Date Formats

If you're formatting a date field, the dialog offers different controls. You can choose from a list of predefined date formats or create your own.

• Automatic: Lets Tableau decide based on context.
• Predefined list: Includes common formats like 3/1/2016, March 1, 2016, 2016-03-01, and Mar-16.
• Custom: This is where you have total control. You can type in format codes to display the date exactly as you want. For example: dddd, mmmm d, yyyy would display as Tuesday, March 1, 2016.

Method 2: Formatting Directly in the View (The "Pill" Method)

Sometimes, you don't want to change the default format. A metric might need to appear differently in various contexts. For example, you might want to show ‘Revenue’ rounded to the nearest million ($2M) on a summary dashboard but show the exact value ($2,143,678) in a detailed table.

In this case, you can format the field directly where it's being used - we call this "pill" formatting because you're formatting the specific instance of the field (the pill) in your Rows, Columns, or Marks cards.

Here’s the process:

1. Drag your field into your Tableau view (e.g., onto the Rows shelf or the Text mark).
2. Right-click on the green (continuous) or blue (discrete) pill you just placed.
3. Select Format... from the menu.

This will open a new Format Pane on the left side of your workspace. This pane is contextual, meaning its options change depending on where you clicked. Typically, you'll have tabs for formatting the 'Axis' and the 'Pane' (the data marks themselves).

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

Axis vs. Pane Formatting

• Axis: Controls how the labels on the X or Y axis are displayed.
• Pane: Controls how the labels on the actual data points (e.g., text labels on a bar chart or values in a table cell) are displayed.

Under either tab, you will find a section for Numbers or Dates. The options here are identical to the ones in the Default Format dialog - Currency, Percentage, Custom, etc. - but any changes you make will only apply to the current worksheet. The field's default properties remain untouched.

Method 3: Advanced Custom Formatting with Calculated Fields

What if you need formatting that changes based on the data itself? For instance, you want to display large numbers compactly with a "K" for thousands and an "M" for millions, but show numbers below 1,000 as-is. Or maybe you need to add a specific word or symbol based on a condition.

This is where calculated fields come in handy. This method involves creating a new field with a formula that determines the output format.

Example 1: Creating Dynamic Number Suffixes (K/M/B)

Let's tackle the K/M/B formatting. The idea is to check the value of a number (like SUM([Sales])) and then return a string that includes the reformatted number plus a suffix.

Create a new calculated field (Analysis > Create Calculated Field...) and use a formula like this:

IF SUM([Sales]) >= 1000000000
THEN '$' + STR(ROUND(SUM([Sales])/1000000000, 1)) + 'B'
ELSEIF SUM([Sales]) >= 1000000
THEN '$' + STR(ROUND(SUM([Sales])/1000000, 1)) + 'M'
ELSEIF SUM([Sales]) >= 1000
THEN '$' + STR(ROUND(SUM([Sales])/1000, 1)) + 'K'
ELSE '$' + STR(SUM([Sales]))
END

Here’s a breakdown of what that formula does:

• It checks if the sum of sales is greater than or equal to a billion, million, or thousand, in that order.
• It divides the number accordingly, ROUND()s it to one decimal place, converts it to a string with STR(), and then appends the correct suffix ('B', 'M', or 'K').
• You then use this new calculated field on your Text/Label card instead of the original SUM([Sales]) field. The one drawback is that this new field is a string, so you won't be able to use it as a number for further calculations.

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: Adding a Prefix or Suffix Conditionally

You can also use calculations to add contextual text. Imagine you want to display profit ratio with an arrow indicating if it’s positive or negative.

IF [Profit Ratio] > 0 
THEN '▲ ' + STR(ROUND([Profit Ratio]*100, 2)) + '%'
ELSEIF [Profit Ratio] < 0
THEN '▼ ' + STR(ROUND([Profit Ratio]*100, 2)) + '%'
ELSE STR([Profit Ratio])
END

This formula adds a “friendly” visual indicator right into your label, making your dashboards easier to interpret at a glance.

Data Formatting Best Practices

As you get comfortable with formatting, keep these principles in mind to create clearer, more effective dashboards:

• Keep It Consistent: A specific metric should look the same across your entire workbook. Use the Default Properties method to standardize your core KPIs. A user should never have to wonder if Revenue on one sheet is the same metric as Sales Amount on another.
• Respect Your Audience: Format for clarity. Use units like "K" and "M" for high-level executive summaries where precision is less important than the overall picture. For analysts who need to see the exact numbers, stick to detailed formats. Also, consider international audiences and their conventions for dates and currency.
• Don't Overdo It: The default two decimal places for currency ($54.32) might be great for an itemized list but distracting on a large-scale trend chart. Adjust the precision to fit the context of the visualization.
• Use Defaults Liberally: Set the default format for every key measure once. It's a small upfront investment that will save you countless clicks and ensure a professional, polished feel for all your dashboards.

Final Thoughts

Mastering data formatting in Tableau is a key step in moving beyond basic charts to building dashboards that are truly insightful and easy to use. By understanding how to use default properties, format within a specific view, and leverage calculated fields, you can control precisely how your data is presented to tell a clearer story.

Learning the clicks and calculations to format your data in Tableau is a great skill, but it highlights the kind of manual work often required to get answers from traditional BI tools. We built Graphed because we wanted to eliminate that friction. Instead of searching menus and writing formulas, our platform lets you simply ask for what you want in plain English, like "show me sales by campaign formatted as currency with a 'K' suffix for thousands," and it instantly generates the right visualization, already formatted and ready to analyze.