Setting color based on value being selectable ( date range selection/navigation )

[#1]

I'm drawing a bar chart with date as dimension and sum( {1} Data.Counter ) as expression, to get a full view of item count over time.

I'd like to set the color of currently selected dates, like this

I know I can set color in the properties of the expression

But I can't figure out the if -expression I should use. Does anyone know how to achieve this? What I'm looking for is something like

if ( CurrentDate IN SelectedDates, RGB(0, 0, 0), RGB(255, 255, 255) )

[marcus_sommer · Accepted solution]

You could try something like this:

if(YourDateField, red())

     or maybe

if(Year = getfieldselections(Year), red())

- Marcus

[hic]

I would use something like

     If(Count(Date)>0, LightGreen(), LightGrey())

HIC

[tresesco]

Or, may be even like,

If(Date=Date, LightGreen(), LightGrey())

Edit: Well,

Marcus's:  if(YourDateField, red())  is even simpler.