Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs
    • SQL FAQ’s

Tableau Bullet Graph

by suresh

Tableau Bullet Graph is similar to a bar chart. Bullet Chart in Tableau is useful to compare One Measure over others 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 a Tableau Bullet Graph with example. For this Tableau Bullet Graph demo, we are going to write the Custom SQL Query against the SQL Server Data Source.

Please visit Connecting Tableau to SQL Server article to understand the Tableau configurations. The custom SQL query we are going to use for this Tableau bullet chart report is:

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 a Bullet Graph in multiple ways:

First Approach to Create Tableau Bullet Chart

This method of creating a bullet chart in Tableau is very easy and straightforward. Please press and hold the control key and then select the Dimension (s), Measure(s) from the respective region, and select the Bullet Graph from the Show Me window.

For this Tableau Bullet Graph example, We are selecting Product name Dimension, Sales Amount, Total Product Cost Measures, and select the Bullet graph as shown below.

Tableau Bullet Graph 1

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

Tableau Bullet Graph 2

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

Tableau Bullet Graph 4

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

Tableau Bullet Graph 5

The second approach to Create Tableau Bullet Chart

This approach of creating a Tableau bullet chart is not the direct way. However, you can control the reference lines and distributions. It is beneficial to analyze data in real-time.

First, Drag and Drop the English Product Name from Dimension Region to Rows Shelf and Sales Amount from Measures region to Columns Shelf. By default, Tableau generates the Bar Chart

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

Tableau Bullet Graph 6

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

Tableau Bullet Graph 7

To convert this Bar chart into a Bullet Graph in Tableau, 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

Tableau Bullet Graph 8

Once you choose the Add Reference Line option, a new window called Add Reference Line, band or Box will open

Tableau Bullet Graph 9

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

Tableau Bullet Graph 10

Following are the changes we made to this reference Line options for Tableau bullet chart:

  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 select, 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
Tableau Bullet Graph 11

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

Tableau Bullet Graph 12

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

Tableau Bullet Graph 13

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

Tableau Bullet Graph 14

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

Tableau Bullet Graph 15

The following are the changes we made to this reference Distributions options for this Tableau bullet graph:

  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 select. However, 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, select the label value; otherwise, select None
  4. Line: Please Specify the Line Width, Style, and color. Here we are choosing 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
Tableau Bullet Graph 16

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

Tableau Bullet Graph 17

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

Tableau Bullet Graph 18

We successfully created a Tableau Bullet Graph

Tableau Bullet Graph 19

Placed Under: Tableau

  • Download and Install Tableau
  • Tableau Start Page
  • Tableau Show Me
  • Connect to MS Analysis Services
  • Connecting Tableau to SQL
  • Tableau Connect to Text File
  • Tableau Connect to Excel File
  • Hierarchies in Tableau
  • Tableau Bins
  • Tableau Parameters
  • Combined Tableau Sets
  • Tableau Set
  • How to Edit Tableau Group
  • Tableau Group
  • Tableau Grouping
  • Tableau First Report
  • Data Labels in Tableau Reports
  • Format Tableau Chart Title
  • Create Folders in Tableau
  • Tableau Sort
  • Add Totals in Tableau
  • How to Join Data in Tableau
  • Tableau Data Blending
  • Tableau Table Report
  • Tableau Crosstab Report
  • Tableau Annotations
  • Tableau Charts
  • Tableau Area Chart
  • Tableau Bar chart
  • Tableau Box Plot
  • Tableau Bubble Chart
  • Tableau Bullet Graph
  • Tableau Bump Chart
  • Tableau Circle Views
  • Tableau Dual Combination Chart
  • Tableau Dual Lines Chart
  • Tableau Funnel Chart
  • Tableau Traditional Funnel Chart
  • Tableau Gantt Chart
  • Tableau Grouped Bar Chart
  • Tableau Heat Map
  • Tableau Highlight Table
  • Tableau Histogram
  • Tableau Cumulative Histogram
  • Tableau Line Chart
  • Tableau Lollipop Chart
  • Tableau Pareto Chart
  • Tableau Pie Chart
  • Tableau Scatter Plot
  • Tableau Stacked Bar Chart
  • Tableau Text Label
  • Tableau Treemap
  • Tableau Word Cloud
  • Tableau Waterfall Chart
  • Tableau Individual Axis
  • Tableau Dual Axis
  • Tableau Blended Axis
  • Tableau Add Reference Lines
  • Tableau Add Reference Bands
  • Add Reference Distributions
  • Tableau Maps
  • How to Create a Map in Tableau
  • Use Google Maps in Tableau
  • Mapbox Maps as a Background
  • WMS Server Map as Background
  • Create a Tableau Dashboard
  • Format Dashboard Layout
  • Create Dashboard Device Prev
  • Tableau Dashboard Objects
  • Create a Tableau Story
  • Tableau Filters
  • Tableau Filters on Dimensions
  • Tableau Filters on Measures
  • Tableau Extract Filters
  • Tableau Dashboard Filters
  • Tableau Data Source Filters
  • Tableau Slicing Filters
  • Tableau Quick Filters
  • Tableau Context Filters
  • Tableau Top Filters
  • Tableau Table Calculations
  • Tableau Calculated Fields
  • Tableau Running Total
  • Tableau Rank Calculation Basic
  • Tableau Rank advanced calculate
  • Tableau Aggregate Functions
  • Tableau Conversion Functions
  • Tableau Case Function
  • Tableau Date Functions
  • Tableau If Function
  • Tableau Logical Functions
  • Tableau Math Functions
  • Tableau String Functions
  • Tableau Table Functions
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy