How to highlight those row yellow color when Closing date less then today

[admin11]

Hi All

i need to detect those deal , when the Closing is less then to day , so that sales staff need to change the closing date after today.

My PBI file

https://www.dropbox.com/s/456sxu2d972zfq3/PBT_V2021_400%20CRM_Ti.pbix?dl=0

[amitchandak · Accepted solution]

@admin11 , Create a measure

color measure =

if(Max(Table[ Closing Date]) <= today(), "yellow", "white")

Set this in conditional formatting for every value using the field value option

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
https://www.youtube.com/watch?v=RqBb5eBf_I4

[admin11]

@amitchandak 

Thank you very much foryour help , it work fine.

Paul