I have a line graph that tracks sales over time. What I want to do is make the background color change (shade it in) when I select a desired selection. We will always see a set number of weeks but if I were to select 'Current month' the most recent 4 weeks background color will change and then the prior 4 weeks background color will change and be different.
The attachment gives a rough idea of the desired effect.
What is the best way to achieve this type of functionality?
See attached qv sample. Look for the background color in the expression to get a better understanding. You can add multiple if conditions depending on your requirement.
The chart colour changes depending on the selection made in the field 'Alpha'
