1.
Create a
Calculated field by the name 2017 Sales and write the formula:
a. If year([Order Date]) = 2017 then Sales End
2.
Create
another Calculated field by the name 2018 Sales and write the same formula as
above but change the year to 2018.
3.
Now drag
Sub-category on Rows.
4.
Now drag
2017 Sales on Column.
5.
Click on
Swap Rows and Columns.
6.
Click on
Entire View.
7. Now drag 2018 Sales onto the x-axis (horizontal), to
form a combined chart.
8.
Now drag
measure names to Color and Size.
9.
Keep size
to medium.
10. Click on Analysis and Select Tick marks Off.
Related Topics
Steps to Create Various Visuals