based on endate condition color has to change and for blank data show white color

[pasupathi]

endate < 3 "yellow color",

enddate>1 "red color"

for blank() "white color"

 

[Anonymous]

Hi  @pasupathi ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Otherwise, the following conditional expressions show that enddate and the value for comparison does not seem to work. Please describe in detail the correct logic of the calculation and the final result you want. Also, please provide some sample data in Text form. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

---

endate < 3 "yellow color",

enddate>1 "red color"

for blank() "white color"

---

Best Regards

[themistoklis]

@pasupathi 

Try something like the below. Change the colour codes accordingly

New Column =
SWITCH (
TRUE (),
TODAY() - Endate < 5, "#D64550",
TODAY() - Endate < 2, "#E8D166",
TODAY() - Endate <= 1, "#79FF00",
"#00000"
)

[ribisht17]

@pasupathi 

Please refer to these links

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

Regards,

Ritesh