A difference bar chart is a type of data visualization that compares the values of two data sets and highlights their differences. This chart type is useful for observing variations and differences between periods, categories, or groups.
A difference bar chart is a powerful visual tool used to compare two data sets and highlight the differences between them. This type of chart facilitates the quick identification of variations and trends, allowing for easier interpretation of complex data.
Tableau offers extensive functionalities for creating and customizing difference bar charts. By using Tableau, you can quickly build intuitive and interactive charts that emphasize key changes in your data.
In this #Skillpill, you will learn how to create a difference bar chart in Tableau, step by step.
→ In Tableau Desktop connect to Sample – Superstore data from Tableau.
→ Create a worksheet named Difference bar chart
→ Create a Calculated field named Sales > 1000 by the following formula:
If[Sales]>1000 then [Sales] end for getting the Sales >1000.
→ Create a Calculated field named Max Sales by the following formula: Max([Sales>1000])
→ Create a Calculated field named Min Sales by the following formula: Min([Sales>1000])
→ Create a Calculated field named Max – Min Sales by the following formula: -([Max Sales]-[Min Sales])
→ Bring Category to Columns
→ Bring Measure Names to Columns with Edit filter on Max Sales and Min Sales
→ Bring Measure Values to Rows with Edit filter on Max Sales and Min Sales
→ Bring Max Sales to Rows
→ Go to Edit Axis and make it Dual axis
→ Go to the Sales axis and set it to Synchronize Axis
→ Go to Marks and make Measure Values as Bar
→ Bring Measure Values on Text
→ Go to Marks and make Agg(Max Sales) as Gant Bar
→ Bring to Agg(Max Sales) the Max-Min Sales to Size and Text and Measure Names to Detail
→ Go to Color Marks on Agg(Max Sales) and make it orange
→ Go to the Marks on Size and increase the size of Measure Values to be greater than Agg( Max Sales)
→ Go on the Text Mark for Measure Values and set the Label to be aligned with Middle Center
→ Right click on Headers and uncheck the option Show Header
→ Right click on the graph go to Lines and select Gridline to None
This has been our #Skillpill in creating difference bar charts in Tableau. We hope you found it informative and helpful. See you next time for more insights and tips!
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?
See how Tableau works, by downloading a free trial here:
In this Skillpill, you will learn how to use tSendMail in Talend. tSendMail is a component used to send emails directly from a Talend job. It supports various email protocols, such as SMTP, and allows the configuration of the sender, […]
🚀 Enhance Your Tableau Dashboards: How to Swap a Different View Parameter! 📊✨ Tableau is one of the most powerful tools for data visualization and business intelligence. Its user-friendly interface and rich set of features allow you to create interactive […]
In this Skillpill, you will learn how to create a Parliament Chart in Tableau. A Parliament Chart, or semicircular chart, represents the distribution of parliamentary seats. It is not a standard chart type in Tableau but can be manually created […]