7 Replies Latest reply on Oct 11, 2018 12:39 PM by Ken Flerlage

    How to do a cell shading using measure values

    Randy Colanta

      I have a tableau report that I'm trying to shade selected measures based on the calculated field.

       

      For example, 1.) Score C measure has a threshold of 95% so any Score C with a value less than 95% the cell should be shaded by color Red. 2.) Score N measure, if the value is less than 60 shade in read, between 60 to 69 shade yellow and 70 and above shade in green. (see Figure A mockup in Excel).

       

      Figure A.

      Figure B (Tableau)

      When I do it in tableau by dragging the calculated field to color marks, it is changing the font color of the entire row for all measures.  Figure A above is the expected results that I am trying to accomplish

      Any tips or assistance will be appreciated. Thanks.