Colors in Stapled Bar Chart with Value list

[BCFi]

Hey there,

lets say I have a Value list with the values: A B and C. I want to show them and their corresponding sub processes (A1-A4, B1-B4, C1-C4) in a stapled bar chart. 

So what I did was:  For the bars I created the ValueList('A','B','C')

and then for every sub process i added bar lenghts. For the Process steps 1 (A1,B1,C1):

If (ValueList('A','B','C')= 'A' , A1, 

IF(ValueList('A','B','C') = 'B',B1 ,

IF(ValueList('A','B','C')='C',C1 ) )
)

I did this for the other subprocesses and I got a nice stapled bar chart. 

All well and good, as long as I do not want to have specific colors for the corresponding sub processes 1 to 4.

By a formula i can give  each process ( A,B,C) a color:

But i want to colorize it by the subprocess steps:

Is there a way? I cannot use the standard colors and unfortunately i cannot change the standard colors- this maybe a workaround... This is so far already way too complicated by the way 😕

Thanks for the help !

[MatheusC]

Olá,  @BCFi 

Você pode inserir suas mídias no item mestre, e insira para cada uma a cor que deseja.

Inserir a expressão e a cor:

Caso tenha ajudado, marque como solução e deixe um like

Grato!

[BCFi]

Hey @MatheusC , 

i am using already Master Elements. But this wont work with value lists :-/.

If i would do it with Master Elements you would need to show me how to create this graph. Maybe you can share an example?

Thansk already !

[BCFi]

Hey there, 

I still could not do it.  Can't anybody help ? Should I explain sth more? 

Best regards!

[BCFi · Accepted solution]

I solved it by replacing the ValueListe for new Master Dimensions: 

One Master-Dimension for the ValueListe ABC, and one Master-Dimension for the Processes. 

Then I created MasterKPI's for the Processes with the content:

count(if(ProcessStep='1', Tasks)). 

Then add the color to the Master-KPI and it works just fine :).