Custom line chart with background shading differentiating last year vs this year

[rajesh9147]

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

[rajesh9147]

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

[KerKol]

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

[KerKol]

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 🙂