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]

          IIF(SUM([Sales])<=10000,SUM([Sales]),NULL)

           

          and

           

          [Sales > 10000]

          IIF(SUM([Sales])>10000,SUM([Sales]),NULL)

           

          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.