Tableau Bullet Graph

Tableau Bullet Graph is similar to Tableau bar Chart. Bullet Graphs are very useful to compare One Measure over other and visualize the result. For instance comparing the Sales this year with last year etc

In this article we will show you, How to Create Tableau Bullet Graph with example. For this we are going to write the Custom SQL Query against the SQL Server Data Source so, Please visit Connecting Tableau to SQL Server article to understand the configurations. Custom SQL query we are going to use for this report is:

T-SQL Query

SELECT ProdSubCat.EnglishProductSubcategoryName, 
       Tery.[SalesTerritoryCountry], 
       Prod.EnglishProductName, 
       Prod.Color, 
       Fact.OrderQuantity, 
       Fact.TotalProductCost, 
       Fact.SalesAmount, 
       Fact.TaxAmt, 
       Fact.OrderDate
FROM DimProductSubcategory AS ProdSubCat
   INNER JOIN
     DimProduct AS Prod 
        ON ProdSubCat.ProductSubcategoryKey = Prod.ProductSubcategoryKey 
   INNER JOIN
     FactInternetSales AS Fact 
        ON Prod.ProductKey = Fact.ProductKey 
   INNER JOIN
     [DimSalesTerritory] AS Tery 
        ON Tery.[SalesTerritoryKey] = Fact.[SalesTerritoryKey]

Tableau Desktop allows us to create Bullet Graph in multiple ways:

First Approach to Create Tableau Bump Chart

This method is very easy and straight forward. Please press and hold the control key and then select the Dimension (s), Measure(s) from respective region and select the Bullet Graph from the Show Me window. For this example, We are selecting Product name Dimension, Sales Amount, Total Product Cost Measures and select the Bullet graph as shown below.

Once you are done, tableau desktop will create a bullet Graph for you as shown below. Let us do some formatting to filter the under performing products.

We applied filter on Product Name Dimension with the following condition. It means, Bullet Graph will display the products whose Sales Amount is Greater Than or Equal to 500,000

Click OK to close the Filters window and see our newly creatd Tableau Bullet Graph

Second Approach to Create Tableau Bump Chart

First, Drag and Drop the English Product Name from Dimension Region to Rows Shelf and Sales Amount from Measures region to Columns Shelf as shown below. By default, tableau will generate the Bar Chart

NOTE: We also applied the above mentioned Filter on Product name

Next, Drag and Drop the Total Product Cost from Measures region to Level of Details filed present in Marks Shelf

In order to convert this Bar chart into Bullet Graph we have to add Reference Lines and Distributions. To do this, Please Right click on the Sales Amount Axis and select the Add Reference Line option from the context menu

Once you select the Add Reference Line option, a new window called Add Reference Line, band or Box will be opened as shown below

By default, Scope will be Per Pane so please change it to per cell and change the value from Sales amount to Total Product Cost

Following are the Changes we made to this reference Line options:

1. Scope: Please change the default Per Pane option to per cell. If you want to add straight or static reference line you can use the default Per Pane option
2. Value: By default, Measure value inside the Row or Column shelf will be selected but you can change as per your requirement. Here we replace the Sum of Sales Amount with Sum of Total Product Cost. Aggregate Value: Please sleet the aggregate function from the drop down list
3. Label: If you want to display the label then select the label value otherwise, select None
4. Line: Please Specify the Line Width, Style and color

From the below screenshot you can observe that, we are closer to the Bullet Graph. Let us add one more reference line to show the Distributions. In order to add, Please Right click on the Sales Amount Axis and select the Add Reference Line option from the context menu

Go to Distributions tab and see the default configuration settings from the below screenshot

By default, Scope will be Per Pane so please change it to per cell and change the Computation value from Sales amount to Total Product Cost

If you want to change the aggregated value, Please select the aggregate function from the drop down list

Following are the Changes we made to this reference Distributions options:

1. Scope: Please change the default Per Pane option to per cell.
2. Value: By default, Measure value inside the Row or Column shelf will be selected but you can change as per your requirement. Here we replace the Sum of Sales Amount with Sum of Total Product Cost. Aggregate Value: Please sleet the aggregate function from the drop down list
3. Label: If you want to display the label then select the label value otherwise, select None
4. Line: Please Specify the Line Width, Style and color. Here we are selecting the None option
5. Fill: Specify the pattern and color for the distributions
6. Please specify whether you want to fill the distributions above and below the Bar Chart by selecting the fields

Click OK to finish configuring the Distributions. If you observe the below screenshot, we got our Bullet Graph

To see the Distributions clearly, Let us reduce the Bar Chart Size using the Size filed present in the Marks Shelf

We successfully created Tableau Bullet Graph

Thank You for Visiting Our Blog