Tableau Dual Combination Chart

The Tableau Dual Combination Chart is handy for comparing one Measure against Other measures visually. In this article, we will show you How to create a Dual Combination Chart in Tableau with an example.

For this Tableau Dual Combination Chart demo, we will use the Data Source we created in our previous article. Please visit the Data Labels in Reports article to understand the Tableau Data Source.

Choose Bar and Line from Show Me Window 1

Tableau Dual Combination Chart Example

To create a Tableau Dual Combination Chart, First, Drag and Drop the Order Date from the Dimensions Region to the Columns Shelf.

Tableau Dual Combination Chart 2

Next, Drag and drop the Sales Amount and Total Product Cost from the Measures Region to the Rows Shelf. Since they are Measure values, both Sales Amount and Total Product Cost values will aggregate to the default Sum.

Once you drag them, a Line Chart will generate, as shown below. For more Charts, Click Here.

Two Line Charts 3

Let me change this to the Dual Combination chart. To do so, Please expand the Show Me window and select the Tableau Dual Combination Chart from it.

TIP: We explained the manual process of creating Dual Combination Charts in the Dual Axis article. So please refer to the same.

Tableau Dual Combination Chart 4

Once you select the Dual Combination from the Show Me window, the Dual Combination Chart will be displayed, as shown in the below screenshot.

Tableau Dual Combination Chart 5

You can Expand these Cards to change Sales Amount to Line, Product Cost to Bar, and so on.

Tableau Dual Combination Chart 6

Let me change the Order date value from Year to All months present in each year to see more Bars and detailed trends.

Tableau Dual Combination Chart 7

Though the below Tableau Dual Combination Chart looks good. However, if you observe closely, the Maximum Axis value of the Sales Amount is 1800K, whereas the Total Product Cost is 1000K.

Tableau Dual Combination Chart 8

If you have no problem, Leave it as it is. Otherwise, please select the Total Product Cost and the Synchronize Axis.. option from the context menu.

Synchronize Axis 9

Now you can see the Dual Combination Chart with Synchronized Axis. You can also remove one axis.

Tableau Dual Combination Chart 10

Add Data labels

To add data labels to the Tableau Dual Combination chart, click on the Show Mark Labels button in the Toolbar.

Tableau Dual Combination Chart 11

Tableau Dual Combination Chart Stacked

You can convert the existing Dual Combination Chart to the Stacked Dual Combination chart. Let me add Country Name to the Colors shelf.

Tableau Dual Combination Chart 12

Highlighting any block will show you the information on that particular slice.

Tableau Dual Combination Chart 13