1, I would like to see how sales perform over time, so I right clicked Order Date to Column and I chose discrete Month. Then, I dragged Sales into Row. The graph appeared as below:
![](https://www.thedataschool.co.uk/content/images/2022/06/image-301.png)
2, I would like to show dots in each Month, so I dragged Sales into the Row once again. I also changed the second Sales line to Circle.
![](https://www.thedataschool.co.uk/content/images/2022/06/Untitled-1.png)
Next, I clicked the drop down menu from Sales and chose dual Axis and right clicked Sales on the right hand side then, I Synchronized Axis.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-308.png)
![](https://www.thedataschool.co.uk/content/images/2022/06/image-309.png)
![](https://www.thedataschool.co.uk/content/images/2022/06/image-310.png)
3, I would like to create a parameter named Sales Target and if the months above or below the target, those months will show different colors.
I clicked the drop down menu on the Data Pane that next to Filter icon and chose Create a parameter and then chose the data type Integer and Current value. After that, I clicked on Sales Target on underneath Parameter on the Data Pane to Show Parameter.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-312.png)
4, I would like to see if Months above the Sales Target show different colors, thus I created a calculation field as below:
![](https://www.thedataschool.co.uk/content/images/2022/06/image-324.png)
Then I clicked Analytics Pane to drag the reference line into the worksheet. I filled the blank by choose value from drop down menu.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-314.png)
As you can see from the picture the reference line is on the bottom, but I want to show the line is in the middle of the sheet if I click a dot. So I set action for Sales Target - the parameter.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-315.png)
First I clicked Worksheet and chose Actions and clicked This sheet and other values like above and then clicked OK on both pages. Now I clicked one of the dot the reference line showed as below:
![](https://www.thedataschool.co.uk/content/images/2022/06/image-316.png)
I wanted to see different colors when Sales above or blow the Sales target not grey out the rest of the Months and dragged Above Sales Target into ALL and SUM(Sales)2. I also created dummy in Calculation field.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-325.png)
I also highlighted the dummy by using Actions and dragged dummy into details in All on the View Cards.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-326.png)
I wanted to show value in reference line so I edited.
![](https://www.thedataschool.co.uk/content/images/2022/06/image-330.png)
![](https://www.thedataschool.co.uk/content/images/2022/06/image-331.png)
![](https://www.thedataschool.co.uk/content/images/2022/06/image-333.png)
Now everything is done.