Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a bar chart with 2 dimensions (year, product) and 1 measure.
I would like to personalize the color of the bars by product :
But if I put the color by expression, the legend disappears :
If(REGROUPEMENT='Produit 1',rgb(235,120,0),
If(REGROUPEMENT='Produit 2',rgb(255,205,0),
If(REGROUPEMENT='Produit 3',rgb(0,120,154),
rgb(0,179,136))))
How can I have the right colors AND the legend?
Hi, @clarachac
Create a master dimension
1- Master items -> Create new -> create your master dimension here
2 - Edit your master dimension, and then in Value colors define the colors by the dimension values as mentioned As shown in the screenshot below
Regarts, Matheus
Hello, by creating a master measure you can choose the color of your dimensions. You then select the color by size, this should meet your expectations.
I want the color by product, how can I create a master measure of Product knowing it's a dimension, I don't understand.
Hi, @clarachac
Create a master dimension
1- Master items -> Create new -> create your master dimension here
2 - Edit your master dimension, and then in Value colors define the colors by the dimension values as mentioned As shown in the screenshot below
Regarts, Matheus
The option will be available after creation, you can add the colors in editing
Ah yess it works! Thank you very much @Clement15 @MatheusC