1 Reply Latest reply on Dec 13, 2016 6:19 AM by Simon Runc

    Help with Heat Map values

    Marina Levin

      I'd like to keep this color display... but for the values over 200 to be represented in black.

      Is there a way to do this in tableau?

      Heat Map2.png

        • 1. Re: Help with Heat Map values
          Simon Runc

          Hi Marina,


          So one way to do this is to set up 2 calculations for the text...


          In the attached (T10) example, I've created 2 calculated fields

          [Sales <= 10000]





          [Sales > 10000]



          I then place them both on the text label tile, and edit them as per the below image



          As one will always be NULL and Tableau doesn't/can't plot NULLs we get the effect we want.


          Hope that helps and makes sense.