Power BI Table Conditional Formatting

[jxkang]

Not sure if this is possible:

I am trying to highlight cells in a table where 

1) If the date is in the past, then green color

2) If the date is in the future, but it is the closest to today compared to other date fields, then blue color

3) If the date is in the future, but it is NOT the closese to today compared to other date fields, then  yellow color

[v-achippa]

Hi @jxkang ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Ashish_Mathur, @Greg_Deckler and @srlabhe for the prompt response. 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @jxkang ,

We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[srlabhe]

Create a measure

DateFlag=if (Date1<today() then 1, 

if(Date2=today() then 2, 0)

use this measure for conditional formatting 

not sure the criteria for Date closer so accordingly change the same

[Greg_Deckler]

@jxkang Is that what your source data looks like or ?

[jxkang]

Hi Greg,
Yes, the dates are in different columns

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.