the pie chart colors are changing when the dashboard refresh is happening

[#1]

Hi All

I have a dashboard which has two pie charts, there is a daily schedule, whenever refresh is happening, the colors are getting displayed differently. I have set up 5 colors for 5 values in pie chart.

For example: the values are A,B,C,D,E,F and corresponding colors respectively.

A=GREEN,B=ORANGE,C=RED,D=BROWN AND E=BLACK.

When dashboard refreshed daily first day, the colors are displaying as per settings and on second day, the colors are interchanging and third day again different colors are getting displayed. Please let me know any settings are needed here.

Thanks in advance for your help.

[satishkurra]

Better do this.

Go to colors tab and set the colors as Variables or In expressions tab, under back ground color, set as below

Example:

if(Product='A', RGB(235,137,35),

  if(Product='B', RGB(239,197,153),

  if(Product='C', RGB(240,220,199),

  if(Product='D', RGB(197,144,88),

  if(Product='E', RGB(120,73,23))))))

[JonnyPoole]

There are some great color regimens you can apply to associate data values with specific color. Try to avoid lengthy UI conditional expressions and instead just load the color expression with each data value in the model

Here is one approach

Changing color of Expressions

Below is something not specific for this situation but is good education on doing color theming. Great color work from Steve Street.

Color Logic – loading multiple Color schemes