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
select by exp and try to write exp lik below
if(sum([Gross Total])>50000 ,red() , if(sum([Gross Total]<10000 ),Green(), Yellow()))
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(),....)
here i have only one client Dimension(only client) with different expression(bars for different expression) for that client.
How could i use this?
apply lik below.. As sunny proposed.
Retrieving data ...