Color scale for dates in table

[Anonymous]

Hi - 

Is there a way to apply Conditional colors by creating a table based on the age of a record?

Example:  a record was:

Updated last 7 days - green

Last update 8-30 days - yellow

Last update >=30 days - red 

In this case - I have a column actually titled "last updated" which refers to a the current status of a record / line item of a table.

Thanks!

[jthomson · Accepted solution]

I'm not sure if it's possible to conditionally format on the date field itself, but if you create a custom column Age = INT(TODAY()-[your last update column]), it should give you a value as an integer which you can then conditionally format based on the rules you have

[pxg08680 · Accepted solution]

@Anonymous

You cannot apply conditional formatting on Date fields. It only applys for calculated values. You may better follow the post by @jthomson and then apply color formatting.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2017-feature-summary/

You may use this link on how to use Color fomatting based on rules.

Regards,

pxg08680

[jthomson · Accepted solution]

I'm not sure if it's possible to conditionally format on the date field itself, but if you create a custom column Age = INT(TODAY()-[your last update column]), it should give you a value as an integer which you can then conditionally format based on the rules you have