Maintain Colors after data refresh

amitchandak 

Thanks.  The solution I need is slightly different.  Using your video as an example, you have Brand 1-13.  Let's say you refresh and now you have Brand 20-33 (i.e. the brands are different names than before).  I need PBI to always use the correct colour order as defined by the theme - but what happens, is that it gives the new brands colours that are not defined in the theme or at least it doesn't start at the first colour.

Any ideas?  I can't define a brand (or other field) by name as they change depending on the data coming into the template.