2 Replies Latest reply on May 17, 2017 12:28 PM by David Lam

    Adding color to row level KPI indicator

    David Lam

      I have the worksheet as set up in the picture. The KPI_Percentage measure is a calc to show an up or down arrow:

       

      If [Percent Variance Calc]> 0 THEN "▲" Else "▼" end

       

      When I drag this on to the "color" Marks shelf, it does changes the color of the "SUM(TotalAmount)" data instead of just the KPI_Percentage column. Any fixes? Can we change the font in the syntax or conditionally?