Yes if you drop your Rotten measure onto your color mark it will color rotten and non-rotten separately. Just change the color for non-rotten to black and it will look like it is now, and color rotten however you'd like.
Thank you for your quick response, I've followed up on your advice and it worked but now I want to take it one step further.
I want to add a 5 step green-red color pallette to only the true values, where the low percentage is green and the higher the percentage gets the more red the numbers get, is this possible?
1 of 1 people found this helpful
Yes Sander, that's possible. Create a calculated field like this - swap out [value] with whatever field you're using for the percentage.
if [Rotten] then [value] end
Drop that on your color mark and make sure it's continuous.