1 Reply Latest reply on Aug 7, 2018 12:27 PM by Mavis Liu

    Color one measure column in a text table

    Matt Wilson

      Hi,

       

      I know this is possible, but I can't wrap my brain around the solutions I'm seeing.

       

      I have a simple table, with one dimension (Job), and two measures (Profit & Sales).

       

      Want it to look something like this (not the text colored, but the background fill colored). 

       

       

      Thanks,

        • 1. Re: Color one measure column in a text table
          Mavis Liu

          Hi Matt,

           

          You can bring in Measure Names into colour, then change the marks type to square. Then add in an adhoc calculation to put some blanks in:

           

          2018-08-07_20h24_27.png

          Update your size in the marks card to be the max size:

          2018-08-07_20h25_03.png

           

          The reason why we had added in the adhoc calculation '' in columns is to segment the columns such that the squares don't overlap into the other measure names.

           

          Then using colour, update the measure name colours:

           

           

          2018-08-07_20h26_34.png

           

          Please see the attached sample workbook.

           

          Thanks,

           

          Mavis