How to color chart by measures. (2 measures)

[Anonymous]

Dear Team,

Please help me. I have two measures & one dimension.

I want to color completed as green and not started as red.

Thanks.

[krishna789]

HI ahamd  albab,

create master measure for each measure and set color for each master measure and darg master measure to chart.

[L_Hop]

Hİ Ahmad,

if you add Completed/NotStarted parameter as a second dimension, you may change the color of the Completed/NotStared parameters like below;

if(Dimension='Completed', green(),

if(Dimension='NotStared',red()))

Add above code to the color by expression tab. you may also use rgb code instead of green()/red() function.

regards;

OY

[jubarrosor]

Hello:

In this case, I use the expresion to calculate the color, for example:

if(COMPLETED_EXPRESSION>0, GREEN(), RED())

It's necesary that the expressions are complementary.

Best Regards.