RGB color in dimension

[yoganantha321]

I have a dimension like this,

=If($(vAllocation)>7 , 'Billable,

  If($(vAllocation)<4 , 'Non-Billable',

  If($(vAllocation)>3 and $(vAllocation)<8 , 'Partially Billable')))

and I have given colors red(),yellow(),green() in color properties of the chart and I didn't give any of the sort options in the chart.

and chart displays as follows

and suddenly it changing as below chart

and while selecting the center bar partially Billable it is displaying as

because of the first bar color as red().

Is there any way to give rgb color in dimension itself as

Example:  If($(vAllocation)>7 , 'Billable'RGB(255,0,0),

Can any one help..........

Regards,

Yoganantha Prakash G P

[parul_mehta]

Is this what you are looking for ?

Background / Text color in the dimension?

You can click on edit, and add the expression like

If($(vAllocation)>7 , 'Billable', blue(),Green());

[yoganantha321]

HI,

I have the whole as

=If($(vAllocation)>7 , 'Billable,

  If($(vAllocation)<4 , 'Non-Billable',

  If($(vAllocation)>3 and $(vAllocation)<8 , 'Partially Billable'))) as calculated dimension in chart

[a_mullick]

Not in the dimension, but in the expression should work.

Thanks,

Azam

[parul_mehta]

Yes, open the dimension ( click on the plus sign ), it will give you option to edit, over there you can add the color ?

If($(vAllocation)>7 , 'Billable', Red(),

  If($(vAllocation)<4 , 'Non-Billable', Blue(),

  If($(vAllocation)>3 and $(vAllocation)<8, 'Partially Billable',LightBlue(), LightCyan())))

Check if this works?

[a_mullick]

Example attached...

Hope it helps,

Azam

[yoganantha321]

It is not working......... Is there any other solution

[a_mullick]

I guess I didn't understand your data model properly. Is it possible for you to share the qvw?

Thanks