Specify color in legend that has a rolling date

[tonys7568]

If you have a rolling date in your legend, is there any way to specify the color of the most recent date? I have gone into Visualizations>>Format>>Data Colors, and it will let you select a color for the dates that are currently listed. But tomorrow, the most recent date will have changed and a new color will be randomly assigned. I'm fine with the colors for the previous dates changing, but I would like to keep the most recent date a specific color. Any way to do this?

[amitchandak · Accepted solution]

@tonys7568 , if you are using legend you can not use conditional formatting. But if you date ax second axis(no legend) -> expand -> sort on both axis -> concatenate label off. Now you can use color using conditional formatting using a color measure

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

[tonys7568]

That does work. It doesn't look the way I would want it to, but that is a limitation of the tool. Hopefully, an enhancement will be made that will just allow conditional formating in the legend.