A selection made on CountryName should not affect the values of graph 2, and I think I have that operating correctly. The problem is when I am coloring by dimension and make a selection on CountryName. Graph 2 colors drop off, but the numbers and dimension values remain. Am I using the wrong dimension or possibly the incorrect background color formula?
Thanks, but this will keep colors persistent based on the load order, I believe. If I load India as another country, for example, this throws the colors off. In this example, I want France to remain green, Mexico to remain blue, and Germany yellow from the Before to After.
I don't mind them being hard coded, and the values are limited, but they can fluctuate between 2 or 5 values loaded in different orders.
Here's the bottom line - I want the top selections to be independent from the bottom and specifically, persistently color-coded.
Here is the BG color formula I use to hard code colors to my countries. The problem is when I select Country Name from the top filter, I don't want this to affect the coloring of the bottom graph (2nd screenshot)
This selection scenario would work if the colors for Mexico and USA remained blue and green respectively, but they revert to the false condition. The # values remain, but why doesn't the coloring as well?