8 Replies Latest reply on Feb 26, 2014 1:55 AM by Akshay Thanai

    Conditional Color formatting based on text

    Akshay Thanai

      Hi guys.  There's a scenario which is making me nuts.


      I am making a dashboard in which one of the sheets look like the below. I have 3 dimensions named "Start Time", "Duration" &  "Result" . I want to color the text of Result. It has only two values as "Success" and "Fail". I want to color the Success in Green and Fail as Red.  How can I do it ?...  

      I tried creating a Calculated filed with the condition


      iif ( [Result] <> "Success", 'Red','Green') .


      Then dragged this calculated field in the Color box. All it does is add a small box [] with the color in the measure fields. I don't want that. I want the text color to be changed.  How should I go about it. ?

      Your help is appreciated.



      Start TimeDurationResult
      Jan 31, 2014 1:00:001:30:00Success
      Feb 1, 2014 1:00:001:00:00Fail
      Feb 1, 2014 3:30:002:00:00Success