Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, everyone!
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?
HI Pedro
Do you have two dimensions?
Try to change the order of the dimensions.
Thanks and regards
Padma
Hi, Padma!
THanks for your reply!
I have two dimensions, but I can't change the order. If I do that, the chart doesn't suport what the client wants.
The client wants the chart showing the top 10 sellers by a quarter.
Hi Pedro
Can you set up the top 10 as a dimension limit
Thanks and regards
Padma
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.
the color of legend is his heart, think about that.
your friend - KILGORE WATTS
Hi,
Can you please post your app, because its giving rite for us.
Hi, Avinash!
It's too much big to post here!
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).
Can you see the pictures above?