Color coding connected columns

[HH3571]

Hello, i have two dimensions(columns) that i use for different graphs, but they practically contain the same data:

Col A	Col B
VIP	Person 1
Person 1	Person 2
Person 2	Person 3
Person 3	Person 4
Person 4	Person 5
Person 5	Person 6
Person 6

The thing is, i would like a unique colour coding for each cell.

My first thought is to define a static data set that assigns a unique colouring for each data input?

So VIP = red, Person 1 = blue........ etc for both columns.

Is this something that is preferred to do in the data load editor? 

If so, can i get some pointers?

Best regards

H

[Taoufiq_Zarra · Accepted solution]

@HH3571  if I understood correctly

you can create [Master items]  a dimension

then in value color you can shoose color or by default each value have a color :