Hello!
I am looking to add color thresholds to a line graph shown below. I have added the average trend line and want the line graph to be green above the average and red below the average. The average is moving, so you cannot just type a number.
5 answers
Hi Allie Bing,
Steps;-
- Create a calculation that will be used to greater than and below then the average values in the line chart.
If SUM([Sales Target])>=WINDOW_AVG(SUM([Sales Target])) Then "High"
else "low"
END
- Add the crated calculation to the colors mark in the sheet as shown below
Select the required color scheme
Final Output:-
I have also added the measure to the labels and selected it to match the marks color this gives a more clear view
Hope this helps.
Regards,
-AV.
