11 Replies Latest reply: Jun 26, 2015 9:33 AM by Shailesh Chaudhri RSS

    Changing color by measure

      Hi all, I have a problem where I want to change the color of the measures separately. Please see the chart below. I want to set all triangles as red if they are above the horizontal line and green if they are below the horizontal line. I want the color of the horizontal line to be red. Right now the line is green. My color expression is the following:

      if(triangle>UpperLimit,red(),green())

      You can see that the one red triangle below. The corresponding segment of the horizontal line is also red. How can I express the color so that the entire horizontal line is red, and that all triangles above the line is red and all triangles below it is green?

       

      Thanks.