Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

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...
General Comment
  • ray_aramburo's avatar
    ray_aramburo
    2 years ago

    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:

     

hackcrr's avatar
hackcrr
Icon for Memorable Member rankMemorable Member
2 years ago

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.