Diverging bar chart and dual axis

Diverging bar chart with one measure and dual axis

A diverging bar chart in Tableau is an efficient method for comparing two categories based on a single measure, clearly highlighting the differences. These charts are particularly useful when we want to emphasize discrepancies between two sets of data or subcategories. 

When there is only one dimension to measure, an independent diverging bar chart can highlight differences between directions.

Moreover, they facilitate a direct comparison between two groups or categories, clearly emphasizing the differences in values. 

Using a dual-axis can provide additional information or highlight other aspects of the data, such as specific values or other relevant metrics. 

Diverging bar charts can be customized according to individual preferences, thus facilitating analysis and the process of making informed decisions.

 

Step 1: Connect to data

→    In Tableau Desktop, connect to Sample – Global Superstore data provided by Tableau.  

Step 2: Create the necessary calculations 

→    Create a calculated field called “Index 1” 

IF INDEX()=1 THEN SUM([Sales]) ELSE -SUM([Sales]) END 

→    Create a calculated field called “Index 2” 

               IF INDEX()=1 THEN SUM([Sales]) ELSE -SUM([Sales]) END 

Step 3: Build the visualization

→    Drag “Index 1” to Columns 

→    Drag “Index 2” to Columns 

→    Drag “Region” to filters and keep only 2 values 

→    Drag “Region” to color on All Marks 

→    Drag “Sum(Sales)”  to Index 1 Mark 

→    Right Click on both Index 1 and 2 and Select compute using –  Region 

→    Right Click on the Index select Dual Axis and synchronize the axis

→ Right-click on both axes and select “None” for both Tick Marks

 

Here is the dashboard in Tableau Public:

 

Watch the video tutorial here:

About btProvider:

We hold all possible technical and sales certifications for all products:

Tableau Desktop, Tableau Public, Tableau Server, Tableau Prep, and Tableau Data Management.

With Tableau Software – the best data visualization platform – you can always understand your business or your job better. Using Tableau, you will make intelligent and strategic decisions and quickly understand the data flow, numbers, and the results it produces. See other #skillpill video tutorials here:

How to display multiple insights on a dashboard in #Tableau

How to create Stacked Bars on Grand Totals in Tableau

How to create a Buffer Zoom in a Tableau Map

Are you interested in learning more about Tableau Software – one of the best analytics tools and implementing the solution in the entire company? 

Contact us!

See how Tableau works, by downloading a free trial here: