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:

     

3 Replies

  • ray_aramburo's avatar
    ray_aramburo
    Icon for Super User rankSuper User
    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:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

       

      Thanks for your help!

       

  • 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.