I have this problem, where I used the formula "=IF(Nome_Administradora_UF = 'DISAL ADM CONS LTDA',Green())" to change the color of only the items where named "DISAL ADM CONS LTDA". I put this formula in the background color of a expression.
The problem is in the legend, where all items gets the unique color when this "DISAL ADM CONS LTDA" is in the chart, just like this:
Someone know how to "fix" this problem? How can I get the correct colors?
Yeah, I did that. THe problem is that the client wants to see the sales of each one of this top ten, just like the first picture. The chart was correct. Just the color in the legend (all green) is the problem. If the item "DISAL" is not in the top 10, the problem doesn't occur.
But the problem is just that: I used a formula to change the color of only one seller (DISAL), but I need the color of the legend like the other itens. One color per quarter/year. When we have Disal item, the color of the bar is changed to green (and it's ok, i'ts what we want), but the color in legend change too (that is what we don't want).