Assign colours manually via datamodel/ Table

[Sander800]

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,

[v-danhe-msft]

Hi @Sander800,

Could you please tell me if your problem could been solved? If it is, could you please close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Sander800,

Based on my research, I am afraid you could not achieve this feature currently, I suggest you submit an idea in ideas forum:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Daniel He