How to create line graph having partial colored background.

[Bhavya98]

Hi All,

I want to create a visual as shown below.

I have taken a line and stacked column chart but with that i am able to achieve this visual as shown below:

I want this green background to cover months till september how can i achieve that?

[MFelix · Accepted solution]

Hi @Bhavya98 ,

For this you need to create a measure and then use it has your values in the bar or the line chart something similar to:

DateColour = if( EOMONTH(MAX('Calendar'[Date]), 0) <= date(2022, 9,30), 1)

Now use this metric has your background:

In my example I use may has the base value but has an example it works properly.