Dynamically format line color of two date snapshots of forecasts (Sample file attached)

[jj6291]

Problem

I have a data set that has snapshots of forecasts. As you can see in the screenshot below, we have forecasts of the same dates, 1 Feb, 1 March, 1 Apr, 1 May at different points in January.

I want to make a plot that compares two snapshots, one in the past and a later one. This is easy to do by creating a new column that links the category and snapshot date (see above). This makes the plot I am after, but the colors are all different and make it hard to read.

Manually changing the colors won't work since the dates will always be changing, so the solution needs to be dynamic.

What I want:

I want to dynamically give the older date one color and the newest date another color so comparisons are easy, for example I did this below.

I tried creating a measure that gets the min and max date of the slicer selection and use that to make a new column that says Category - Old or Category - New depending on it's asatdate, but that didn't work for me. Open to other ideas, im sure there is a simple fix that I am missing.

Thank you!

Here is a link to a sample file i made:

https://drive.google.com/file/d/1cUyt8vnuyfNKWDCOdynAqSnFPiS57GZH/view?usp=sharing

[amitchandak]

@jj6291 , Conditional formatting is not supported in line visual. Also, the marker color workaround does not work when using legend

[jj6291]

Yes, but if I create a column that classifies the before and after date, then I can use that in the legend field right?