Different colors for different bars

[#1]

Hi Experts,

IN my attached qvd, i have 8 products. I want the first 3 products to be in red (bar color), the next 3 in yellow and the last 2 in blue. How this can be achieved.

Thanks

[#2 · Accepted solution]

Hi Yousuf,

You have to enable the multicolor properties into presentation tab.

accordingly you can change your color PFA. for your Reference.

[#3]

thanks..it now looks so simple

[jvishnuram]

Hi Yousuf,

You can also use the background color in the expression, find the attachment.

[#5]

Hi Vishnu,

Can you paste the expression here since i am working from home and currently don't have access to the licensed version.

Thanks

[jvishnuram]

Hi Yousuf,

This is the expression,

=if(Product='Accessories' or Product='Laptop' or Product='Monitor'

,Green(),

if(Product='Notebook' or Product='Printer' or Product='PS3',Red(),

if(Product='Scanner' or Product='Server',Yellow())))

and you need to be paste here,find the attachment

[#7]

Hi,

you can use pick function .

properties->expression->expand ->+->Backgroundcolor->Defination

=pick(match(Product,'Laptop','Desktop','Keyboard',red(),blue(),green())

.i hope it will give better performance.

ihopw it will be helpful to you.

PFA,

regards

Mahesh

[#8]

awesome...thanks