Conditional Formatting Date in Card Visual

[Chris_Evans]

I have a card visual  that displays a date from a field in my data model. I would like to be able to use conditional formatting to change the color of either the background or the text if the date is beyond a certain threshold compared to today's date, ie color it red if greater than 30 days ago. I haven't been able to figure out if that is possible or not. I found the conditional formatting for the visual but was unable to successfully get it to work. Thanks for any help I can get.

[amitchandak · Accepted solution]

@Chris_Evans , You can create a color measure and use that in conditional formatting

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"lightgreen","red")

Or

Color Date =

Var _max =maxx(Table,Table[date])

return

if(FIRSTNONBLANK('Date'[Date],TODAY()) <_max ,"lightgreen","red")

Refer:https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...

[Chris_Evans]

@amitchandak 

That worked perfectly. I just added -30 to the statement to get the results i needed. Thank you.

ColorDate = if(FIRSTNONBLANK(AgendaUpdates[last_update],TODAY()) <today() - 30,"red","black")