Hi, I'm having trouble understanding how colors are automatically assigned to field values, or more precisely, why do these colors randomly change upon one reload and then go back to default upon another.
Basically, I have a field with 3 values that I'm using as the top level in a drill-down dimension - for that reason, I cannot set colors for the values myself but rely on automatic ones.
As seen in print-screens attached, default colors for field values are: light blue for A, purple for B and dark blue for C. After some of the reloads (I did not figure out at what frequency and why), the colors for A and C switch: A becomes dark blue and C light blue. It's always these two values that switch color, no more values appear (nor will) in this field, values are in alphabetically ascending order and usually upon next reload the colors go back to default.
Colors for these 3 values are essential for the report I'm building and need to be persistent. I'm using this field as a part of drill-down dimension by which simple stacked bar chart is split (so bar colors are inherited from automatic field values colors).
In addition, on combo charts with 3 stacked bars and 3 lines (one for every field value, measure color set to correspond to default field value color) colors are not the same as in simple bar charts if field value colors switched upon reload.
Please let me know if you have a solution for this issue or if there is anything that can be done for development side to prevent this issue from happening.
Have you tried sorting the fields during the reload? (Order by) I believe the colors are assigned based on whatever value is loaded first, second, etc.
