Forum Discussion
Date Colouring According to due dates
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...
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
Super User
Super UserAnonymous , 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