Is it possible to have a fixed color for the Total bar in a chart

[#1]

Hi All,

I have a bar chart that has a cycle group and an expression. The "Show Total"  option has been enabled (in the presentation tab) and a bar shows the Total. However, when I change the dimension using the cycle group, the color of the Total bar changes. However, I want the Total bar to always display the same Color. Is there some way I could do this?

Thanks,

Neeraj

[#2]

Try

If(IsNull([Dimension]), RGB(255,0,0)) on the background color expression

Where [Dimension] is your bar chart dimension.

Of course, this only works well if there are no empty dimensions possible.

[tduarte]

Thanks. That didn't worked for me but this worked:

if(not(isnull(Dimension)),color(1))

Multicolored and Repeat Last Color options ticked on Colors tab.