Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is my condition which i am using for color by expression .If(DIFF_AMOUNT < 0,RGB(255,0,0),RGB(34,139,34))
However my graph shows a wrong color (ie green) in the -30 to -25 range, when in fact should be red.
Thanks in advance,
Cheers,
Tanay
are you sure your measure is DIFF_AMOUNT ?
maybe is:
If( Sum(DIFF_AMOUNT) < 0,RGB(255,0,0),RGB(34,139,34) )
Hope it helps.
In the below expression use complete measure expression instead of "DIFF_AMOUNT ", so that it will work based on bar value.
If(DIFF_AMOUNT < 0,RGB(255,0,0),RGB(34,139,34))
Hi Tanay,
If(left(DIFF_AMOUNT,1)='-',RGB(255,0,0),RGB(34,139,34))
Hi Andrea,
actually The measure is - Count (distinct [Property No])
To color the bar chart, I am just using color by expression and providing If(DIFF_AMOUNT_EMAIL < 0,RGB(255,0,0),RGB(34,139,34))
as the expression there.
Hi Rangam,
Tried it, but no luck there.
Hi Kaan ,
Still giving the same graph
Try this
If((Count (distinct [Property No])<=0),RGB(255,0,0),RGB(34,139,34))
what is your dimension here?
my dimension is
Dual(Replace(class(DIFF_AMOUNT, 5),'<= x <', '-') ,class(DIFF_AMOUNT, 5))
Looks like, you want color based on the dimension you have defined (i.e. ranges), so you need to try different approach not on measure.
You can try based on the value you have used for deriving those range dimensions.