3 Replies Latest reply on Oct 2, 2018 8:26 AM by Mavis Liu

    Formatting Text Color Based on Dimension and Measures

    Ryan Blank

      Hello - I have a request for one of my dashboards but I'm not exactly sure of how to go about doing this. I have tried to replicate my situation with the Superstore data.

       

      Essentially we want to format the color of the text based on bot the Segment (Dimension) and the Profit Ratio (Measures). In this example, we would want to shade the text green if the Segment = Consumer and the profit ratio is >10%. If it's less than 10% we would want it red.

       

      However with following segment, Corporate, we would want to shade the text green if the profit ration is >15% and red if it's less than 15%.

       

      Is this something that is possible?