Try like this,
Go to expression -->Text Color -->
if( ISHCQTYAvailable >=0 ,rgb(0,128,0),
if( ISHCQTYAvailable < 0 ,rgb(255,0,0),
rgb(0,0,0) ) )
Thanks for your post and instructions...
That's exactly what I did and it works in a straight table but not a pivot table..
I have no Null values in thus dimension (there was a bug that was mentioned elsewhere about NULLs and colour)
Does your colour work if your chart is a pivot Table?
same thing unfortunately - works in straight table but not in a pivot table...
got me scratching my head... i need this in pivot table format, and i don't want to make this an expression... I don't understand why this won't work in a pivot table....
anyone come across this?
I appreciate your feedback...
Can you please explain what <Column (2)> represents in your picture?
If my dimension is <QTYAvailable> isn't that what I should be referencing in my colour expression?
if ou could let me know that would be great...
if( len((ISHCQTYAvailable) > 0, Green(),
if( len((ISHCQTYAvailable) < 0, Red(), Black()
I can't Pratik unfortunately,
it is way too large and it connects to our in house ODBC, plus it's confidential information...
I understand this makes it hard though and appreciate any help...
Column (2) is my measurable value.
You have to take reference for your column on which criteria you want to color your dimension above screen shot showing sales % wise therapy with background color