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 Data Labels in Reports article to understand the Tableau Data Source.
Tableau Dual Combination Chart Example
To create a Tableau Dual Combination Chart, First, Drag and Drop the Order Date from the Dimensions Region to Columns Shelf.
Next, Drag & 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, Line Chart will generate as shown below.
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.
Once you select the Dual Combination from the Show Me window, the Dual Combination Chart will be displayed, as shown in the below screenshot.
You can Expand these Cards to change Sales Amount to Line, and Product Cost to Bar, and so on.
Let me change the Order date value from Year to All months present in each year to see more Bars and detailed trend.
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.
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.
Now you can see the Dual Combination Chart with Synchronized Axis. You can also remove one axis.
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 Stacked
You can convert the existing Dual Combination Chart to the Stacked Dual Combination chart. Let me add Country Name to the Colors shelf.
Highlighting any block will show you the information on that particular slice.