Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Duplicate (but independent fields) as data island

I am having trouble with this comparison scenario using a data island, and properly colorizing a bar chart by dimension values.

Graph 1 - Sum(sales)

Graph 2 - Sum({<CountryName = p(Island.Country)>} Sales)

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?


13 Replies
Partner - Contributor III
Partner - Contributor III

Perfect, thank you!

As an aside, I was curious if there's a way to have the same coloring functionality, but with Island.Country as the dimension instead of CountryName. There is still dependency between the two if I make a selection within the bottom chart, since it uses the original CountryName field.

Specialist II
Specialist II

Check the attached sample.


May be use this in script in end of the script?

Left Join(Island)

LOAD * Inline [

Island.Country, R, G, B

France, 244, 66, 66

Mexico, 66, 244, 98

USA, 66, 134, 244


And use BG Color expression like RGB(R,G,B)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Specialist II
Specialist II

Even after the background color expression you need to check 'Persistent Color'.