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 backg...
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.

     

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.