Line Chart - Change color of line based on a give date

[zeke101]

Hello,

I have 2 data sets - the first dataset contains the raw data that I want counted in the line chart.  The data contains multiple sites and we are trying to count the effectiveness of a new algorithm that was released on a certain date.  So my 2nd dataset contains the site and the date of the change of the algorithm.  I'm wanting the visual to show different colors on the trendline depending upon when the algorithm was deployed. 

Example: If site ABC123 had the new algorithm deployed on 10/15/2021 all the volume prior to 10/15/2021 would be black and everything on or after 10/15/2021 would be red. 

[zeke101]

So I was able to figure out how to do a color change for one line........

but when trying to add 2 lines, I lose the conditional formatting.

Is there a way to do both lines? or just create some sort of indicator on that date with both lines (doesnt necessarily need to be a color change) ? 

[VijayP]

@zeke101 

Is this you want

[zeke101]

@VijayP 

Yes, something similar --- each "Zone(Location)" has a date and so based on that date, I need the color of the graph to change similar to how you show in your screenshot. It needs to be dynamic as there are multiple dates for specific "Zone(Location)".