Skip to main content

Hi All,

 

What is the easiest way to achieve this in tableau.

I have 1 dimension column call "Group ID"

The requirement is to set the back ground color of each row based on the group id,

Ex: If the Group Id=1, the back ground of the cells for that row should be Yellow.

      If the Group Id=2, the back ground of the cells for that row should be Green, etc.

Format all table columns based on the value of one of the column

 

Please find the attached file for the workbook.

 

Thanks

 

Regards,

Ratna

7 risposte
  1. 5 feb 2018, 05:36

    Hi Ratna,

     

    Step 1 - drag group id to colour shelf

     

    Step 2 - invert your data and uncheck 'show headers'

     

    Step 2 - edit your label to align the data in the format you want

     

    Step 3 - drag your measure (or number of records) onto marks card and assign to size

     

    Step 4 - change marks to Bar

     

    Step 5 - change size to max (so that it creates a colour line through the data

     

    Hi Ratna, Step 1 - drag group id to colour shelf Step 2 - invert your data and uncheck 'show headers' Step 2 - edit your label to align the data in the format you want Step 3 - drag your measure (or n

     

    HTH 10.4 attached

     

    Peter

0/9000