Pie chart help

[bhavvibudagam]

Hi Experts,

Can any one please help me on below issue.

I am unable to apply colors to pie chart. ONLY able to apply single color.

Please help me on this when i show in auto or in color by dimension its showing like this only.

Thanks in advacne

[Chanty4u]

did you tried ?appearance--colors and legend --custom color  by dimension

[Chanty4u]

if not try with expression  [instead of dimension]

if(type='value1',RGB(253,208,0),

if(type='valu2',RGB(169,169,169),RGB(0,0,0)))

[HarishG]

Try this in color by expression :

ColorMix1( rank(total EXPRESSION ) / NoOfRows(TOTAL) , Color1, Color2)

[bhavvibudagam · Accepted solution]

This expression is working fine.

pick(mod(rank(TOTAL column(1))-1,5)+1 ,argb(255,189,0,38),argb(255,240,59,32),argb(255,253,141,60),argb(255,254,204,92),argb(255,255,255,178))