topic Re: Background clolor in DAX Commands and Tips

Background clolor

Bergh — Thu, 31 Mar 2022 05:46:57 GMT

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

Re: Background clolor

amitchandak — Thu, 31 Mar 2022 06:46:38 GMT

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

Re: Background clolor

Bergh — Fri, 01 Apr 2022 09:06:41 GMT

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?

Re: Background clolor

Icey — Mon, 04 Apr 2022 07:40:40 GMT

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.

Re: Background clolor

Bergh — Mon, 04 Apr 2022 08:25:15 GMT

Thanks!! It work now!!