First of all, we start with a simple bar graph showing the SUM of Sales by Order Date month:
![](https://www.thedataschool.co.uk/content/images/2022/03/Picture1-15.png)
We then need to create an Integer parameter, for this example let’s call it ‘Sales Range’:
![](https://www.thedataschool.co.uk/content/images/2022/03/Picture1-16.png)
We now need to go to our ‘Analytics’ tab and drag the ‘Average Line’ onto our graph:
![](https://www.thedataschool.co.uk/content/images/2022/03/Picture1-17.png)
Right click onto the ‘Average’ line that appears and select ‘Edit’ to bring up the below window:
![](https://www.thedataschool.co.uk/content/images/2022/03/Picture1-18.png)
We then need to change the ‘Value’ to be the ‘Sales Range’ parameter that we have just created (you can also tweak the formatting to your preference):
![](https://www.thedataschool.co.uk/content/images/2022/03/Picture1-19.png)
On the ‘Data’ tab, you will then need to right click on ‘Sales Range’ and select ‘Show Parameter’:
![](https://www.thedataschool.co.uk/content/images/2022/03/Picture1-20.png)
Now that the parameter is showing you will be able to adjust the ‘Sales Range’ and see the reference line move accordingly.
We now need to create a second calculated field to get our values that are above the ‘Sales Range’ to highlight in a different color. We will call this ‘sales above ref?’ and will need to reference our ‘Sales Range’ parameter:
![](https://www.thedataschool.co.uk/content/images/2022/03/Picture1-21.png)
We then need to drag ‘sales above ref?’ onto color:
![](https://www.thedataschool.co.uk/content/images/2022/03/Picture1-22.png)
Now as we adjust our ‘Sales Range’, the months that are above our ‘Sales Range’ will turn orange and the ones below will remain blue:
![](https://www.thedataschool.co.uk/content/images/2022/03/Picture1-23.png)