Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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());
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
Not in the dimension, but in the expression should work.
Thanks,
Azam
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?
Example attached...
Hope it helps,
Azam
It is not working......... Is there any other solution
I guess I didn't understand your data model properly. Is it possible for you to share the qvw?
Thanks