Visual Cues

[Anonymous]

Hi guys,

I have some data within a table..

Is it possible to highlight all the months previous to the current month in red? For example January to May all need to be in red..

Thanks

Mel

[m_woolf · Accepted solution]

In Chart Properties, click the + in front of your Month dimension and double-click on Background Color.

Enter something like:

if(YourMonthField<Month(Today()),red())

You can substitute rgb(xxx,xxx,xxx) for red() if you want more precise control over the color.

[krishnacbe]

Try to write a expression to color as below

if(Month(Date)< month(Today(), red(),Green())

[Anonymous]

Awesome! Thanks very much