Forum Discussion
Background clolor
Bergh , You can create column meausre
COlor =
Var _max = max(Table[Datediff])
return
switch(True() ,
left(Max(Table[Column1]),2) = "No" && _max >=-14 && _max< 0 , "Yellow",
left(Max(Table[Column1]),2) = "No" && _max > 0 , "Red",
"White"
)
How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4
Use this in conditional formatting using field value option
The problem I have now is that the "No" don't recognize in the code:
If I take away the "No" thing, the color work but when in the "No" code everything get White. Can it be the Max in LEFT(Max that is the problem?
Hi Bergh ,
Please check the attached .pbix file. It's a sample. Please check if there are any differences between your scenario and the sample.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks!! It work now!!