Conditional Formatting on Values that are = 0, < 0 and > 0.

[lamlam24]

In my power bi report, I am trying to create a conditional formatting for values that meets the following conditions. 
if Value = 0 (green) 

if value > 0 (red)

if value < 0 (red). 

the matrix visual below is what I have in my report 

Let's take a look at the 4 AM column. The measure for this column gives the following values
0, 0.1, -0.6 and 1.8. 
I want the background color for 0 to be green 

background color for 0.1 and 1.8 to be red 

background color for - 0.6 to be red. 

please help. 
thank you. 

[Uzi2019 · Accepted solution]

Hi @lamlam24 

use below dax for conditional formatting

Color 4am= If(Sum( value)=0,"Green", If(sum(value)<0, "Red", "Yellow")
It gives you 3 color

but you have written red in both condition then formula would be this

Color 4am= If(Sum( value)=0,"Green", "Red")

then put this value under Cell element > background color

then select fied the seect your measure

I hope I answered you question!

[MNedix]

Hi,

This should be quite easy and straight forward - see link below:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting 

If this answered your question then please mark it as the solution so others can see it.