Date Colouring According to due dates

[Anonymous]

Hi everyone,

I am new to Power BI and I have a task to do. I need to sort the expiry dates in the "License Expiry Date" field according to overdue (Orange), 15 days before deadline (Red), 30 days before deadline (Yellow) and more than 30 days (Green). One more important point is there are some empty fields in the "License Expiry Date" field and these fields must not have any colours on it.

Is there a way for conditional formatting to colours those cells with dates in it while keeping the empty cells untounched?

Thanks.

[Anonymous · Accepted solution]

Hello @Anonymous ,

We can achieve it by creating one measure and using it in the conditional formatting of the date values as shown below.

Thanks,
Neel

[amitchandak]

@Anonymous , Assume you can create a measure like

days left = sumx( today(),Table[License Expiry Date],day)

Color Measure =Switch(True() ,

[Days Left] <= 15, "Red",

[Days Left] <= 30, "Yellow",

"Green"

)

Use this in conditional formatting using the field value option

PowerBI Abstract Thesis: How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4