Conditional Formatting Measure

[HenryJS]

Hi all,

How can I create a conditional formatting measure which states:

If [advert created] =< ([job registered] + 3 days) THEN Green

If [advert created] > ([job registered] + 3 days) THEN Yellow

If [adverted] = "No" THEN Red

[amitchandak · Accepted solution]

@HenryJS , Create a color measure use in conditional formatting with field value option

Color = Switch( True() ,
max(table[advert created]) =< max([job registered]) + 3 , "Green",
max(table[advert created]) > max([job registered]) + 3 , "Yellow",
max([adverted]) = "No","Red"
)

refer for step: https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values