Color in stacked bar

[sergio0592]

Hi all,

I can't manage the following issue. I have a stacked bar chart with two dimensions dim1 and dim2. Dim2 has the values : RED/GREEN/YELLOW/GREY.

So when Dim2=RED, i want background color is red. It works only for some cases but not for all. I use a table color (which usually fix the issue) and as background color :

=color or =only({<Dim1>}color) but both don't works.

Any idea?

Thanks

[hopkinsc]

Hi, can you post an example?

[sergio0592]

I can't manage to reproduce the issue on a sample for the moment.

[sergio0592 · Accepted solution]

I manage to fix it with trying reproducing in a sample.

As expression i have a cumulative sum of sales with =

sum({$<MONTH={"<=$(=num(MONTH))"}>} SALES)
/
sum({$<MONTH={"<=$(=num(MONTH))"}>} TOTAL <Dim1> SALES)

So it works if as background color i have = Only({<MONTH>}   color)