Tableau Data Blending Tutorial

What Is Data Blending in Tableau?

Data blending in Tableau combines summarized results from two or more separate data sources in one worksheet. Tableau queries each source independently and then blends the returned data through one or more shared fields, usually dimensions such as Date, Region, Customer, or Product Category.

The first data source used in the worksheet becomes the primary data source. Any additional source contributing fields becomes a secondary data source. The primary source defines the marks retained in the view, so a blend behaves similarly to a left join at the aggregated result level rather than joining individual rows before aggregation.

When Tableau Data Blending Is the Right Choice

Use data blending when related data must remain in separate connections or cannot be combined conveniently in the data model. Typical cases include comparing actual sales stored in a database with targets stored in an Excel file, combining published data sources, or working with sources that have different levels of detail.

• Compare actual values from one source with targets, budgets, or forecasts from another source.
• Combine data from systems that cannot be joined directly through a cross-database connection.
• Keep each source at its own level of detail and blend only the aggregated results needed in the worksheet.
• Use a published data source together with a separate local or server-based source.

For most new workbooks, first consider Tableau relationships or joins. Relationships preserve separate logical tables while allowing Tableau to determine suitable joins during analysis. Joins combine rows within the data source. Blending is a worksheet-level technique used after Tableau has queried and aggregated each source separately.

Primary and Secondary Data Sources in a Tableau Blend

The order in which fields are added matters. The source of the first field placed in the view becomes primary and is marked with a blue check mark in the Data pane. A secondary source used in the same worksheet is marked with an orange check mark.

Tableau links the sources through common dimensions. When matching fields have compatible names and data types, Tableau may create the link automatically. An active linking field is indicated by a link icon in the secondary data source. If the fields have different names, define the relationship manually by mapping the corresponding fields.

How Tableau Blends Data Across Separate Sources

1. Tableau sends a separate query to the primary data source and each secondary data source used in the worksheet.
2. Each source returns aggregated results at the level required by the view.
3. Tableau matches the secondary results to the primary results through active linking dimensions.
4. The blended values are displayed together without creating a single row-level table.

Because the blend occurs after aggregation, changing the dimensions in the view can change the result. The linking fields must also use compatible data types and matching member values. For example, East in one source will not match Eastern in another source unless the values are standardized or aliases are used appropriately.

Tableau Data Blending Example: Sales Compared with Sales Plan

This example uses two data sources: Sample – Superstore Sales and an auxiliary Excel spreadsheet containing planned sales. The objective is to display actual sales by segment and category, then compare those values with the corresponding sales plan.

1. Build the view from the primary sales source

• Connect to Sample – Superstore Sales (Excel) and build a view that shows Sales by Customer Segment and Product Category.

Because the first fields in the worksheet come from Sample – Superstore Sales, Tableau treats it as the primary data source.

2. Connect the Sales Plan secondary source

• Select Data > Connect to Data and connect to the Sales Plan spreadsheet.

• Drag the Sales Plan measure to the Level of Detail shelf.

In newer Tableau Desktop versions, the command may appear as Data > New Data Source. After connecting, confirm that the dimensions used to match the two sources have active link icons in the Sales Plan data source.

3. Add the Sales Plan reference line

• Right-click the Sales axis and select Add Reference Line.
• In the Reference Line dialog box, add a reference line that shows Sales Plan per cell. When finished, click OK.

Using a per-cell reference line allows each segment and product category mark to be compared with the corresponding planned value returned by the secondary source.

4. Read the blended actual-versus-plan view

• The Worksheet is now pulling data from the secondary data source (Sales Plan) to show how actual sales compared to the forecasted sales.

The bars represent actual sales from the primary source, while the reference lines use Sales Plan values from the secondary source. Check the aggregation and linking dimensions before interpreting any difference between the two measures.

How to Define or Edit a Tableau Data Blending Relationship

If Tableau does not detect the correct linking fields, open the relationship settings for the primary and secondary sources and map the fields manually. Choose fields that represent the same business value and have compatible data types.

1. Open the worksheet and identify the primary and secondary data sources in the Data pane.
2. Choose Data > Edit Blend Relationships.
3. Select the primary and secondary sources that must be related.
4. Use the automatic relationship when the detected fields are correct, or select a custom relationship and map the matching fields.
5. Return to the worksheet and verify that the required link icons are active in the secondary source.

A blend can use more than one linking field. For example, monthly regional targets may require both Region and Month. Using only Region could repeat or over-aggregate the monthly target, while using only Month could combine unrelated regions.

Tableau Data Blending vs Joins and Relationships

Method	Where data is combined	Level of combination	Best suited for
Data blending	In the worksheet after separate queries	Aggregated results	Separate sources, published sources, or different levels of detail
Join	Within the physical data model	Rows	Tables that can be combined with a defined join condition
Relationship	Within the logical data model at query time	Context-dependent	Related tables that should retain their own level of detail

Choose a join when row-level combination is required and the join cardinality is understood. Choose a relationship when tables belong in the same Tableau data model but should retain independent logical structure. Choose blending when the sources must stay separate or when worksheet-level aggregation is intentional.

Common Tableau Data Blending Problems and Fixes

Secondary values appear as null

Confirm that the correct linking field is active, the data types are compatible, and the member values match. Also check whether a primary-source filter has removed the members needed to match the secondary source.

Secondary measures are duplicated or unexpectedly aggregated

Review the level of detail in the view and the fields used for linking. Add the necessary dimensions to the view or activate additional linking fields so that Tableau blends at the intended grain.

A field cannot be used as a linking dimension

Linking fields must be dimensions with compatible data types. Convert the field type, create a calculated dimension, or standardize the underlying values before blending.

Changing the primary source changes the result

This is expected because the primary source determines which members are retained. Rebuild the worksheet by placing a field from the intended primary source first, then add fields from the secondary source.

Tableau Data Blending Limitations to Check

• Blending works with aggregated results, so it is not a replacement for a required row-level join.
• The primary source controls the domain of values shown in the worksheet.
• Nonmatching values and incompatible data types can produce null secondary results.
• The level of detail in the view and the active linking fields directly affect the returned measure values.
• Some calculations and filtering behaviors differ between primary and secondary sources, so results should be validated carefully.

Tableau Data Blending FAQs

Is data blending the same as a left join in Tableau?

No. It resembles a left join because the primary source controls the retained members, but blending combines separately aggregated query results rather than joining row-level tables.

Why is the secondary data source showing null values?

The linking field may be inactive, the field values may not match, or the sources may use incompatible data types. Verify the link icon and compare the actual member values in both sources.

Can Tableau blend more than two data sources?

Yes. A worksheet can use one primary source and multiple secondary sources, provided each secondary source has a valid relationship to the primary source for the fields used in the view.

Can measures be used as Tableau blending links?

Data blending links are normally based on dimensions, not measures. Use dimensions that identify matching members, such as Date, Region, Customer ID, or Product Category.

Should I use data blending or relationships in Tableau?

Use relationships when the tables can be part of one Tableau data model and should retain their logical levels of detail. Use blending when the data sources must remain separate, such as when combining a published source with another connection.

Editorial QA Checklist for This Tableau Blend

• Confirm that Sample – Superstore is the intended primary source and Sales Plan is the intended secondary source.
• Verify that every active linking field represents the same business value and uses a compatible data type in both sources.
• Check that Sales Plan is aggregated at the same segment, category, date, or regional grain shown in the worksheet.
• Test at least one known segment-category combination against the source files to confirm the blended value.
• Confirm that null values indicate genuine missing matches rather than inactive links or inconsistent labels.