Forum Discussion

Bhavya98's avatar
Bhavya98
Regular Visitor
3 years ago
Solved

How to create line graph having partial colored background.

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?

Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    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.

     

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    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.