Forum Discussion
Custom line chart with background shading differentiating last year vs this year
Hi All,
I have a requirement to compare last year data with current year data with a line chart and show the differentiation using background color shading. For ex, all the months in the last year 2020 should have a background shading with one color and current year 2021 with a different color shading. Sample attached. If exactly the same is not possible then, any other closeby ideas also appreciated.
Thanks
Raj
3 Replies
Hello,
You can do this with the X-Axis Constant line:
With the in-built line visual, in the Analytics Pane:
Add a line, set the date hardcoded or using a formula.
Add shading and data label.
Let me know how you go 🙂
Hello,
Thanks for your reply. I have tried the X-Axis Constant line and I got the background shade for the last year. I am looking for 2 lines with the current year and last year but I am missing all month's information on X-Axis. I have attached the latest screenshots.
When I apply Type Continuous, I am able to see the background and missing Feb 2021 on X-Axis.
When I apply Type Categorical, I am able to see All month's information but not the background.
Please let me know if I missing anything here.
Thanks,
Rajesh
Howdy, I'm please it worked 🙂
That is expected behaviour for continuous axes, as they are continuous, there is no need to plot all values, especially if it is a measure that can be split into fractions.
Data: Continuous vs. Categorical (eagereyes.org)
You should be able to add a second constant line on a continuous axis:
and then add shade after
