How to Add Values in Tableau

Adding values to your charts is the first step in turning an interesting visualization into a truly insightful one. Without specific numbers, a bar chart just shows relationships, with them, it tells a concrete story about performance. This guide will walk you through several practical ways to add and display values in Tableau, from the straightforward mark label to the more powerful calculated field.

Showing Values Directly with Mark Labels

The simplest way to display a numerical value on a chart is by using Mark Labels. Every bar, point, or segment in your Tableau view is a "mark," and you can label it with its corresponding value directly from your data.

Imagine you have a simple bar chart showing sales for different product categories. It’s useful to see which category is bigger, but it’s more useful to know the exact sales figure for each.

How to Add Mark Labels:

1. Create your basic visualization. For this example, drag the Category dimension to Columns and the Sales measure to Rows to create a bar chart.
2. In the Data pane on the left, find the measure you want to display as a label. In this case, it’s SUM(Sales).
3. Click and drag the Sales measure directly onto the Label card within the Marks shelf.

Instantly, Tableau adds the sales value to each bar on your chart. You’ve now gone from a relational view ("Technology has the highest sales") to a quantitative one ("Technology has $836,154 in sales").

Customizing Your Mark Labels

Once you’ve added labels, you can customize them to improve readability.

• Formatting: Click on the Label card in the Marks shelf. A dialog box will appear. Here you can change the font, size, and color of your labels. You can also make them bold or italic.
• Alignment: In the same dialog box, you'll find alignment options. You can position the label at the top, middle, or bottom of a bar, and align it left, center, or right. For a standard bar chart, vertically aligning to the middle and horizontally to the center often looks cleanest.
• More Context: You aren't limited to just one value. You can drag another field, like Profit, onto the Label card as well. Or, click the three-dot button (...) next to the Text field in the Label options to open the text editor, allowing you to create custom labels like "Sales: &lt,SUM(Sales)&gt,."

Displaying Information with Tooltips

Tooltips are the informational pop-ups that appear when you hover your mouse over a mark on a visualization. They are enabled by default and provide a great way to add more values and context without cluttering up your visualization with labels.

Think of them as on-demand details. Your main view might show just sales, but a tooltip can reveal sales, profit, quantity sold, and the discount rate all at once.

How to Customize Tooltips:

1. Navigate to the Marks shelf and click on the Tooltip card.
2. This opens the Edit Tooltip dialog box. You’ll see the existing fields that are currently in the tooltip.
3. To add another value, find the desired field in your Data pane and drag it onto the Tooltip card. Now it will be available to use in the editor.
4. To edit the text, simply type in the editor window. You can change the structure, add descriptive text, and format the text (bold, color, size). For example, you could change the default tooltip to something more readable:

&nbsp,&nbsp,&nbsp,&nbsp,<,Category>, &nbsp,&nbsp,&nbsp,&nbsp,Total Sales: &lt,AGG(Sales)&gt, &nbsp,&nbsp,&nbsp,&nbsp,Total Profit: &lt,AGG(Profit)&gt, &nbsp,&nbsp,&nbsp,&nbsp,Quantity Sold: &lt,AGG(Quantity)&gt,`

The fields in angle brackets &lt,&gt, are placeholders for the data values. By customizing tooltips, you create a cleaner primary view while still providing rich, detailed information for users who want to explore the data more deeply.

Adding Totals and Subtotals for a Bigger Picture

Sometimes the "value" you need to add is a summary, like a grand total at the end of a table or subtotals for a group of categories. Tableau's Analytics pane makes this incredibly easy.

Let's say you have a table showing sales broken down by Category and then Sub-Category. Adding totals provides a complete view of performance at different levels.

How to Add Totals Using the Analytics Pane:

1. Create a view with at least one dimension and one measure. For instance, put Category and Sub-Category on the Rows shelf and Sales on the Text label card to build a text table.
2. On the far left, switch from the Data pane to the Analytics pane.
3. Under the Summarize section, you will find Totals. Drag it from the pane and drop it onto your worksheet.
4. A small box will appear, giving you options like Subtotals, Column Grand Totals, or Row Grand Totals. Select the option that fits your needs. Choosing Subtotals will add a summary for each main Category.

Alternatively, you can add totals from the top menu by navigating to Analysis > Totals and choosing from the context menu. This method gives you the same options and is useful if you prefer navigating menus over dragging and dropping.

Creating New Values with Calculated Fields

The most powerful way to add value to your analysis is by creating entirely new measures with Calculated Fields. These are formulas you write to derive new data from your existing fields, such as creating a profit ratio, calculating the difference between two dates, or flagging data based on criteria.

Most real-world analysis requires going beyond the raw fields in your dataset. Calculated fields are where you build custom logic and KPIs for your business.

Example 1: Calculating Profit Ratio

Profit Ratio is a common KPI, but it's often not in the raw data. You can create it easily.

1. In the Data pane, right-click and select Create Calculated Field.
2. Name your new field something clear, like "Profit Ratio."
3. In the formula box, type the expression: SUM([Profit]) / SUM([Sales])

Using SUM() tells Tableau to first add up all the profit and sales for a given mark (like a category bar) and then perform the division. This is crucial for working with aggregated data.

1. Click OK. You'll see "Profit Ratio" appear in the Data pane under Measures.
2. Now you can use this field anywhere. Drag it to the Color card to see which categories are most profitable, or put it in a tooltip to display the ratio. You can also right-click it, go to Default Properties > Number Format, and select Percentage to ensure it always displays correctly.

Example 2: Creating a Conditional Label with an IF Statement

Let’s say you want to quickly tag sub-categories as either "Profitable" or "Unprofitable" to add clear visual flags.

1. Create another new Calculated Field named "Profitability Status."
2. In the formula box, write a simple IF-THEN statement:

IF SUM([Profit]) > 0 &nbsp,&nbsp,&nbsp,&nbsp,THEN 'Profitable' &nbsp,&nbsp,&nbsp,&nbsp,ELSE 'Unprofitable' END

1. Click OK.

This calculated field returns a piece of text (a string) instead of a number. Now, you can drag "Profitability Status" to the Color card. Tableau will automatically assign two different colors, one for "Profitable" and one for "Unprofitable," instantly highlighting the performance of each sub-category.

Using Reference Lines to Add Context

A value on its own often lacks context. Is $50,000 in monthly sales good or bad? A reference line helps answer questions like this by adding a constant, average, or another comparative value directly to your axis.

Let's add an average sales line to a chart showing sales over time.

How to Add a Reference Line:

1. Create a view, such as a line chart showing Sales by Month.
2. Switch to the Analytics pane.
3. Drag Reference Line from the pane and drop it onto your chart. You can add it per "Table," "Pane," or "Cell." For a simple chart, dropping it on Table will apply it across the entire visualization.
4. A dialog box pops up. Under Value, you can choose what the line should represent. By default, it’s often set to SUM(Sales) with a computation of Average. This is exactly what we want.
5. Under Label, you can choose to display the computed value (Computation: Value), just the value (Value), a Custom label, or None.
6. Click OK. You will now see a line running across your chart representing the average monthly sales, providing immediate context to which months were above or below average.

Final Thoughts

Mastering how to add and display values transforms Tableau from a simple chart-making tool into a powerful platform for analysis. Whether you’re adding simple labels, customizing detailed tooltips, summarizing with totals, creating new KPIs with calculations, or adding context with reference lines, each method helps you build more informative and actionable dashboards.

Learning the syntax and interface of a tool like Tableau takes time, but getting the insights you need shouldn't have to be a complicated process. At Graphed , we help you skip the technical learning curve by connecting directly to your marketing and sales data sources - like Google Analytics, Shopify, and Salesforce - and letting you build dashboards and reports using simple, natural language. Instead of clicking through menus or learning formulas, you can just ask a question like "show me my sales pipeline from HubSpot" and get a live, interactive visualization instantly.