Unbelievable Add Secondary Axis Tableau
Then grab the same measure with Control key pressed and drop it again on the row shelf.
Add secondary axis tableau. To add a custom subtitle clear the Automatic check box. Ad Organize Present Data Intuitively Get Insights on the Spot. Ad Organize Present Data Intuitively Get Insights on the Spot.
At this point you need to decide whether or not the two axes should be syncronized. Right-click the second measure on the Rows shelf and select Dual Axis On the Marks card labeled All set the mark type to Bar in the dropdown menu On the Marks card labeled SUM Sales Click Size and then adjust the slider to change the width Repeat step 4 on the Marks card labeled SUM Profit. Drop the measure in the row shelf.
In this example the Sales axis is the secondary axis and the Profit axis is the primary axis. You will have two instance of the same measure on the row shelf. Select Secondary Axis for the data series you want to show.
Right Click the second measure on the row shelf and click dual axis. In our case Sales is on the left Y-Axis. Select Design Change Chart Type.
Skip Ahead to the Tricky Bit if youre already a Ninja. For example we may want to create a chart where Primary Y-Axis represents Total Sales and. Dual Axis charting in Tableau is a cinch in fact when I teach seminars on Tableau I typically show three different ways to achieve the end result.
To do this right click on the Profit axis and select Synchronize Axis. Httpsbitly31Wg2RoWe are ready t. One of the best ways to show year over year data when comparing two measures is to do a combined axis chart in Tableau.