Color by measures

[kermitt]

Hello,

I have several columns inside my tab which deal with a measure.

All of these measure is a value in percent that represent a part.

The sum of all these measure for a given dimension (as portfolio) is 100% in absolute value

I have built a stacked bars chart to represent all these measures.

1 - I would like to color all of this measure with a RGB value not by using the chromato colors

2 - For each dimension I would keep only the 3 first major values to display

Can you help me ?

[kermitt]

In other way is it possible to affect color on a measure by using an expression

For exemple : if my measure (wich deals with the name column) name is "toto" can I use an if statment for exemple to say :

if (measure='toto', blue

if (measure='titi', green....etc

Isn't it better to do this by the set analysis. I am stuck ! If someone could help me

Warm regards