if statement with Hexa colors

[Maciej29]

I'm looking for solution to get custom bar colors using expression if and hexa colors.

Status	Color
Received	2d7fef
First Touch	8d46ad
In Progress	e05631
On Hold	732477
Finished	41a64f

Thanks in advance for any tip.

[mato32188]

Hi Maciej,

you can define color by expression like

pick(match(Status,'Received','First Touch'),'#2d7fef','#8d46ad')

BR

m

[Dalton_Ruer]

If you are going to use Status in lots of charts throughout the application you can create a Master Dimension for Status. Then you can use the colors anywhere you use Status.

[Maciej29]

Hi Dalton,

I need it only for single chart and it's vizlib bar chart . So I would stand with using expression in this case.