we have a problem statement related with color coding in Tableau.
Simplified sample scenario:
We have 2 calculated fields – X & Y.
If X > Y , we should show both fields in Green color//#ED1C24
If X=Y , we should show both fields in in Orange color #FFCE06
If X<Y, we should show both fields in in Red color #E62125
IF X> Y THEN “#ED1C24”
ELSEIF X = Y THEN “#FFCE06”
ELSEIF X<Y THEN "#E62125"
3) Place the calculated field on the Color shelf
If X= 100 & Y =100
Both X& Y should be displayed in “#FFCE06” color
Both X& Y is getting displayed in“#FFCE06” color in only certain sheets, not in all sheets .
Color code is getting reflected properly only in a certain sheets of a dashboard.
Other Items I can see that calculation is success but color code is not getting reflected.It shows different colors
Tableau shows inconsistent behaviour while dealing with color codes.
Looking for support to fix this issue.
Any help is appreciated.
Are you saying that #FFCE06 is not being displayed in green, or are you saying that X and Y are not the same colors?
If it is the first case, you cannot set color with a formula. The fact that it was green on some of your sheets is a coincidence - you would usually have to set the colors manually.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...