Assign colours manually via datamodel/ Table

I have a report that is being used by many countries. The products in the report get a colour assigned using my json template.

However, each country wants to choose which colour they want to add for each product. Since we have >100 products this is nearly impossible to do by hand in the visual.

Is there a way I can add a (colour?) code to the products in the masterdata table based on which the product will get a colour assigned in the visual? This way I would not need to assign  >100 colours in the template and will also provide the countries the flexibility to assign their colour preference to products.

For instance add a column in which I could put the colour code (hex, RGD).

Or a number wich would relate to the colour in the json template (all products with number 1 would get the first colour of the template, all products with numer 2 the second colour etc.)

KR,