A Bullet Graph in Tableau is a compact and powerful visualization used to compare a primary measure against one or more target or benchmark values, making it ideal for performance tracking and KPI monitoring. It shows how well a value is performing relative to goals in a clear and space-efficient way.
- Displays actual performance against a target
- Uses bars and reference lines for comparison
- Ideal for KPI and performance dashboards
- Replaces traditional gauge charts
- Helps identify under- or over-performance quickly
Dataset used can be downloaded from here.a
Implementation
Steps to illustrate a the Bullet Chart in Tableau:
- Open the Tableau tool and connect a dataset to it.
- Drag and drop the one sheet of the connected dataset.
- Click on Sheet1 to open the Tableau worksheet.
- On clicking Sheet1, you will get the whole dataset attributes on the left side and a worksheet for work.
- To draw a bullet graph you have to select a minimum of three attributes (two in the row and one in the column) by drag and drop then select the chart option as a bullet.
Example 1
Market as the column and Sales and Profit as the rows.
Example 2
This example is also drawn similar to above example 1 with some extra marks and which is explained in steps given below:
- Select the Region and Sales fields as column and row respectively.
- Select the chart type bullet graph.
- Apply marks by color of profit.
- Apply marks by details of shipping mode.
Example 3
This example is also drawn similar to above example 1 with some extra marks and which is explained in steps given below:
- Select the Category, Sub-Category and Profit fields as column and row respectively.
- Select the chart type bullet graph.
- Apply marks by color of discount.
- Apply marks by details of sales.
