Background clolor

[Bergh]

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

[amitchandak]

@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

[Bergh]

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?

[Icey · Accepted solution]

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.

[Bergh]

Thanks!! It work now!!