3 Replies Latest reply on May 22, 2013 7:05 AM by Brad Llewellyn

    Tableau 7 - How can you colour NULL values on a grid with diverging colour values?

    Jake Pearson

      I have a data grid with colours based on a % value. In some instances I have some NULL values where there would be a DIV/0 error. I would like to highlight these by changing the colour of the cell to grey.

       

      Example:

       

      12
      A£10£20
      B£92£50
      C£56

      £76

       

      e.g. I want to be able to colour cell B,1 grey for instance as the metric % is NULL. The label is Metric 1 and the colour is Metric 2 (the %).

       

      Does anyone know how to do this? I am probably overlooking something very simple!

       

      Thanks guys!

       

      Jake