Color Mix wizard

[#1]

HI,

I like to give two different color based on expression result using color mix wizard ,the formula used in expression is

(Sum([Units])/ Sum(total [Units])* 100 - Sum({1<PeriodID={$(=PeriodID-1)}>}[Units])/ Sum(total [Units])*100)/1000

if the expression value > o it should display color with green and the value less than o(zero) should display with red color.

Plz,help me out wat expression to be given in color mix value expression and in the upper and lower (..) areas.

THANKS IN ADVANCE

[#2]

hi,

if i am able to understand your problem ,

if(round((Sum([Units])/ Sum(total [Units])* 100 - Sum({1<PeriodID={$(=PeriodID-1)}>}[Units])/ Sum(total [Units])*100)/1000 ) >0,green(),red())

regards,

Ravi

[#3]

Go to visual cues and set the upper to whatever you wish to, and set the lower to 0 so that the lower than 0 number will display red and the higher numbers will display green

[#4]

Hi,

its working

can you explain this with using colormix wizard to display the color.

if possible explain in detail with screen shots..

thanks,,,

[#5]

Hi,

I agree with Ravi..just an additional info you can put this formula in the font color of the chart you are doing.

Regards,

[#6]

Hi,

Any other option like this in charts(bar chart).

pls,,if possible explain with screenshots..