Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
Please help me. I have two measures & one dimension.
I want to color completed as green and not started as red.
Thanks.
HI ahamd albab,
create master measure for each measure and set color for each master measure and darg master measure to chart.
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
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.