This is a duplicate question of this post: Re: How to assign multiple colors for single measure on stack bar chart
Please do not post the same question multiple times. To be honest, the original question is a mess while this one is much better. However, since the question was already asked and people have put effort into helping answer that original question I am locking this duplicate. Please continue to use the original thread.