For your first point, maybe you could create a palette which only have five colours in it?
On your second point, I am not sure I follow - if you only have five branches, then they only have their own region and city and so the entire list wouldn't show, right?
Have a good day!
Thanks for your reply.
Let me explain scenario again:
I have created a dashboard in which branch level analysis is done on various KPI's, the user can select max 6 branches or I would say, the dashboard should not run if the user has not selected 6 branches ( which is not happening today, my first problem statement)
secondly, my color mark card is set to Branch Name and Branch name dimension has 100 values. I have assigned color palette also, each time I am changing the branch name, a palette is packing up branch name color automatically.
Since a user can select max 6 branches, I want to restrict colors to 6,
any suggestion plz