Red and green conditional formatting matrix visual in Power BI... Need help!

[Anonymous]

I don't understand how make this kind of rules working.

I'm just trying tu make the text gree if the valueit's over 0, and red if it's under.

Thanks for any further suggestions.
AG

[hackcrr]

Hi, @Anonymous 

I have the following matrix:

It is suggested that you can create a metric similar to the following:

Measure 2 = IF(SUM('Table'[count])>40,"green","red")

This metric will be used in the conditional format of the matrix

The results are as follows:

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ray_aramburo · Accepted solution]

Change two things:

1) The order of the clauses (first you should evaluate for those less than 0).

2) The first dropdown should be Number, not percentage.

See example:

[Anonymous]

Thanks for your help!