Advanced Charting : Bar Under Bar

Hi All,

In today blog I will write about how we can create a bar chart within a bar chart . This is how a bar under bar charts looks. I have used the Sample Super store data for this illustration :

bar_Bar

 

To do this we create two calculated fields that would give us the sales for 2014 and 2016 respectively.
Step 1: 2014 Sales

2014 Sales

Step 2 : 2016 Sales

2016 Sales

Step 3: Bring category to the Columns and Sales(2014) to the columns. Select bar Charts.bars

Step 4: Place the measure Sales (2016) on the axis and this the following view that you will get .
bar2.PNG

Step 5: Drag the measure name to the column and from the dropdown of Analysis select Stack Marks > Off. This is what your screen should look like now.
bar 3

Step 6: Now press Ctrl and drag measure name to the size mark . Adjust the size to get the desired result .
Final

 

Hope you guys enjoyed it . Do let me know if you are not able to follow.

 

Thanks.
Rahul Singh

Please follow and like us: