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

    Color one measure column in a text table

    Matt Wilson



      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). 




        • 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:



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



          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:





          Please see the attached sample workbook.