not able to get 'By dimension' option in Colors and legend for bar chart

[berryandcherry6]

Hi,

i want to apply different colors to bars in bar chart,for this i have set auto color off,but i am only getting 3 options in dropdown not getting by dimension option.

here i have one dimension : client name

5 Expression ,each bar for each expression

Please help me on this

[Chanty4u]

select by exp and try to write exp lik below

if(sum([Gross Total])>50000 ,red() , if(sum([Gross Total]<10000 ),Green(), Yellow()))

[sunny_talwar]

So are you trying to get a color for each of your bar? May be try sort by expression:

Pick(Match([client name], 'Client1', 'Client2', 'Client3'.....), Blue(), Green(), Black(),....)

[berryandcherry6]

HI,

here i have only one client Dimension(only client) with different expression(bars for different expression) for that client.

How could i use this?

[Chanty4u]

apply lik below.. As sunny proposed.