How to Show Multiple Measures in Tableau

Displaying a single measure in Tableau is easy, but the real power of data analysis comes from comparing multiple metrics at once. Seeing sales, profit, and shipping costs side-by-side, for instance, tells a much richer story than looking at each one in isolation. This article will show you several practical methods for visualizing multiple measures in Tableau, from simple side-by-side bars to more advanced dual-axis 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 Bother Showing Multiple Measures?

Analyzing metrics in a silo can be misleading. You might see rising sales and assume everything is going great. But what if your profits are shrinking during the same period? Or your marketing spend is skyrocketing with diminishing returns? Visualizing multiple measures in a single chart provides critical context and reveals the relationships between different parts of your business.

Doing this allows you to:

• Compare Performance Directly: Easily see if profit is growing in line with sales or if a marketing campaign's cost is justified by the conversions it generated.
• Identify Correlations: Spot patterns that might otherwise be missed. For example, you might notice that when your average order value goes up, your customer satisfaction score dips slightly.
• Create Richer Dashboards: Combine KPIs into a single, cohesive view to give stakeholders a comprehensive understanding of business health without overwhelming them with dozens of separate charts.

Method 1: The Quick and Easy Way with "Measure Names" and "Measure Values"

The most straightforward way to display multiple measures in Tableau is by using the special fields Tableau generates: Measure Names and Measure Values. Think of "Measure Values" as a container that holds all the metrics in your data set, and "Measure Names" as the labels for each of those metrics.

Let's build a simple bar chart comparing Sales, Profit, and Quantity across different product categories.

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. Drag your dimension, such as Sub-Category, onto the Columns shelf.
2. Drag the Measure Values field from the Data pane onto the Rows shelf. By default, Tableau will create a bar chart a bit like a big traffic jam, with every measure in your dataset showing up for each sub-category. Don't worry, we'll fix that.
3. In the Marks card area, a new card will have appeared labeled "Measure Values." This card lists all the measures currently being displayed. To clean up your chart, simply drag the measures you don't want to see out of this box. For our example, keep only SUM(Sales), SUM(Profit), and SUM(Quantity).
4. Finally, to make sense of what you're seeing, drag the Measure Names field onto the Color tile in the Marks card. Tableau will now assign a unique color to each measure, and a helpful color legend will appear.

You now have a clean stacked bar chart showing the composition of totals for each sub-category. But what if you want to compare the bars side-by-side?

Variation: Creating Side-by-Side Bar Charts

This is a small tweak to the previous method and is perfect for directly comparing the absolute values of different measures.

1. Start with your dimension (Sub-Category) on the Columns shelf and Measure Values on the Rows shelf.
2. Just like before, filter the "Measure Values" card down to the metrics you need (Sales, Profit, Quantity).
3. Here's the key difference: instead of dragging "Measure Names" to Color, drag Measure Names onto the Columns shelf, right next to your Sub-Category pill.

Instantly, your stacked bars will transform into grouped, side-by-side bar charts, one for each measure. This makes it incredibly easy to see which sub-category had the highest sales, the highest profit, and the highest quantity sold, all in a single view.

Method 2: Comparing Different Scales with a Dual-Axis Chart

What happens when you want to compare two measures with completely different scales? For example, revenue in millions of dollars and click-through rate as a small percentage. Putting them on the same axis would render one of them invisible. This is the perfect job for a dual-axis chart.

A dual-axis chart gives you a second Y-axis, so each measure gets its own scale while sharing the same X-axis. This is also how you can create combination charts, like overlaying a line on top of a bar chart.

Let's visualize Sales (bars) and a calculated Profit Ratio (line) over time.

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

Step-by-Step Instructions:

1. Drag your date dimension, like Order Date, to Columns. Right-click the pill and choose a continuous date part, like "Month (May 2015)."
2. Drag your first measure, Sales, to the Rows shelf. You'll get a simple line chart.
3. Go to the Marks card for the SUM(Sales) layer and change the mark type from "Automatic" to "Bar".
4. Now, drag your second measure, Profit Ratio, to the Rows shelf. This will place a second chart below the first one.
5. Find the Profit Ratio pill on the Rows shelf, right-click it, and select Dual Axis.

And there it is! Your Profit Ratio line chart is now overlaid on top of your Sales bar chart, with one axis on the left for sales and one on the right for profit ratio. You have two different Marks cards now—one for each measure—so you can edit their colors and styles independently for maximum clarity.

A Quick Tip: If your two measures on a dual-axis chart do share a similar scale (e.g., Sales and Target Sales), right-click one of the axes and choose Synchronize Axis. This locks both axes to the same scale, ensuring you're making a true apples-to-apples comparison.

Method 3: Blending Measures with a Shared Axis

This technique is subtly different from Method 1 but provides a clean way to plot multiple measures on the exact same axis. It's ideal for comparing trends between two metrics that share the same unit and a similar scale, like 'Sales' and 'Profit'.

Instead of manually manipulating Measure Names and Measure Values, you can use Tableau's drag-and-drop capability to combine them.

Step-by-Step Instructions:

1. Drag Order Date to Columns (let's use continuous Month again) and Sales to Rows. This gives you a standard line chart for Sales.
2. Now, drag your second measure, Profit, from the Data pane and hover it directly over the vertical axis of your chart (the one for Sales). Wait until you see a faint green, two-cylinder icon appear, then release.

Tableau works some magic behind the scenes. It automatically places Measure Values on the Rows shelf, moves Measure Names onto the Color mark, and filters the Measure Values card to include only Sales and Profit. The result is a single chart with two beautifully colored lines sharing one common axis, perfect for comparing their trends over time.

Method 4: Using Small Multiples to Avoid Clutter

Sometimes, putting multiple lines on a single chart can create a "spaghetti chart" that’s impossible to read. A great alternative is creating "small multiples," which is a series of small, consistent charts placed in a grid. This allows for easy comparison across different categories without overlaying them.

Let's create separate trend lines for sales in each Region.

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. Start with a simple visualization: Order Date on Columns and Sales on Rows.
2. Drag the dimension you want to use for your grid, like Region, onto the Rows shelf and place it before the SUM(Sales) pill.

That's it! Tableau creates a separate row for each region, each with its own sales trend line. This makes it instantly clear how sales trends differ between the Central, East, South, and West regions. You can apply the same logic to measures. By dragging Profit onto the Rows shelf before Sales, you would get a row for Profit trend and another row below it for Sales trend.

Final Thoughts

Mastering these different techniques—using Measure Names/Values for direct comparison, dual-axis for different scales, shared axes for similar trends, and small multiples for clarity—will dramatically improve your Tableau reporting. By combining measures intelligently, you move beyond simple charts and start creating dashboards that tell a compelling and comprehensive data story.

Of course, the goal is always to get answers faster. While Tableau is an incredibly powerful tool for those willing to master its intricacies, it often involves a lot of clicks, drags, and configurations. At Graphed we created a way to get these same insights without the steep learning curve. You can connect your marketing and sales data sources in seconds, then simply ask for the chart you want in plain English, like "Show me a bar and line combo chart of my sales vs profit ratio by month" and get an interactive, real-time dashboard instantly. It automates away the setup so you can spend your time acting on insights, not building charts.