Forum Discussion
How to disabled legend color changes ?
Hi Anonymous
If so, I think it would be better to fix the sites in the legend. You can try adding a Dim table which includes all site values in a column. Create a relationship on site columns between the Dim table and your original Fact table with single direction and one-to-many cardinality. Then put Dim table's site column into the chart as Legend. In this way, the colors should be fixed.
Jing
Hello,
I think that the problem come from the fact that it is not always the same sites in the legend. And so even if I set colors in the data color section, if a new site appears, all colors are refreshed.
Community SupportHi Anonymous
If so, I think it would be better to fix the sites in the legend. You can try adding a Dim table which includes all site values in a column. Create a relationship on site columns between the Dim table and your original Fact table with single direction and one-to-many cardinality. Then put Dim table's site column into the chart as Legend. In this way, the colors should be fixed.
Jing