two charts have different colors. If I click in “Business View” on A3, chart 1 and chart 2 should have the same color. How can I set the colors?
You need to uncheck the persistent color option on the chart properties, find the attachment hope it will helps you.
In two charts you used different dimensions, you are using site and site3 in charts, if you use the same dimension site then you will get the same colors, otherwise you need to hard code or define the colors for each of the Value in the dimension.
You can set colors with an expression.
Expand the plus sign (left) so that you can write an expression for Background Color.
Then you can use an expression to set desired colors.
Retrieving data ...