I need the color palette to reset by manager, that way, when you look at the a single manager you don't see the same colors. This has been an issue that I can resolve manually, but is not optimal. I don't want to use separate palettes and I don't want to use a gradient by manager, just assign a grouping the color assignment that determines the pallet should reset and start assigning from the beginning again.
The attached demonstrates this with a treemap, but I have similar use cases when assigning colors by region/territory on a map.
This is more a enhancement request than a support question, but if someone has worked around this it'd be great. I'm typically connecting to SSAS, so my options for calculated columns and such are more limited.