Forum Discussion
Background clolor
Hi. I have a problem. I have a column that should show different background colors. I can not do this via condition control.
I have three columns. One column with Yes and No, one column with dates and a third with Datediff. I have combined the Yes and No column and the Date column into a separate column as in the picture. What I want is that if it says Yes or No and is over -14, it should be unchanged.
If it says No and is between -14 to 0, the background should be yellow, if it says No and is more than 0 to Max, the background should be red. How do I fix this??
Thanks
// Mattias
4 Replies
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?
