4 of 4 people found this helpful
@Therashasank there's a way around this, it just needs a little arithmetic.
@Jonathan - I believe you've set up your color palette like this, is that correct?
There are two things going on here:
1) The Start & End settings for the color ramp are telling Tableau that everything below (for Start) or above (for end) those values will get the appropriate end color of the range.
2) All values in between the -0.15 and 0.15 are evenly distributed across the color ramp, which in your case has been reduced to three colors - red, white, and green. So red goes from below -0.15 to -0.5, white from -0.5 to 0.5, and green from 0.5 to .15 and up. I set up an example using CoffeeChain data:
Amaretto/Oregon/2013 is -5.26% and is red, while Caffe Mocha/New Hampshire/2012 is -4.8977% and is white.
Therefore, to get your color ramp we need to adjust the end points so Tableau's algorithm will spread them evenly across the range. If you want white from -0.15 to 0.15 that's a range of 30 points. So the spread needs to be 30 * 3 colors = 90 points. Since you're diverging in both directions from 0 that means 90/2 = 45, so the end points need to be -0.45 and 0.45:
Then the color ramp will break at the right points, in this case Columbian/Oregon/2013 is 14.8% and Decaf Irish Cream/Iowa is at 15.2%:
These are approximations, if you want exact values you might need to tweak the end points slightly (I'll probably play with this over the next couple of days to see).
Depending on your data and your view there might be an option for using a Discrete (blue) pill based on a calculated field, if you provided more details about your view and what is displayed (for example there are two measures on Measure Values but I'm only seeing one in the view in the screenshot) I could take a look.
Hey Jonathan, 100% correct. Was using two measure values in my example, as many as four on the dashboard I'm building. Guess my understanding of the banding was a bit lacking, but your solution seems to work perfectly.