Total Column color in Bar Chart

[#1]

Hi,

I have a Bar Chart with "Show Total" checkbox selected for my dimension.

Total info is correctly displayed but bar color is the same of the rest of columns .. How can I set a specific color for this Total column?

"Total color"  from Colors Tab is not being used ..

Thanks,

T

[#2]

I've found this way to do it

if(Dimensionality()=0,color(2)) in Background color Expression column

Although this does not clarify me why "Total Color" from Colors tab is not being automatically applied ..

[Gabriel]

Hi,

Have you tried Multi Color from Colors tab in chart properties?

If not give it a go and let us know if this work.

Regards,

Gabriel.

[tduarte]

Hi, also trying to set a fixed color for the Total bar in QV10..

Already tried if(Dimensionality()=0, LightRed()) on the Expression -> Background Color but it doesn't work.

Really simple on a table but not working on the chart.

Any ideas?

[Gysbert_Wassenaar]

Try something like:

if(match(MyDim, concat(distinct MyDim ,',')),color(1), color(2))

Replace MyDim with the name of the dimension you use in your bar chart

[tduarte]

Nice one, it works!

Thanks.