Challenge: Analyzing Profit Changes Between 2016 and 2017

Your task is to create a bullet graph to compare the Profit from 2016 and 2017 across different categories.

1. Drag the "Sub-Category" field to the Rows Shelf .

2. Drag the "2017s Profit" field (created in the previous chapter) to the Columns Shelf .

3. Drag the "2016s Profit" field to the Marks area and place it under "Detail" .

4. Add a Reference Line :

   • Set the Value to "2016s Profit" ;

   • Set the Aggregation to "Total, Per Cell" .

5. Customize the Reference Line by adjusting the color and transparency to make it more visible.

6. Review the chart to identify categories with negative "2017s Profit" but positive "2016s Profit" .