0 Replies Latest reply: Jan 8, 2018 1:26 PM by krishna b RSS

    Expression for custom color for measures

    krishna b

      Hi All,

      I created Two  measures and one Expression for Color.


      My Expression For conditional color: It is giving same color for 2 bars.

       

      If($(=Round(Avg([Unavailability%])))<>0,RGB(0,0,255),

      if($(=Round(Avg([Overall Availability%])))>=98,RGB(0,128,0),

      If($(=Round(Avg([Overall Availability%])))>=97,RGB(255,255,0),RGB(255,0,0))))

       

      Pls help me.

       

      Thanks,

      Krishna