Create several color models depending on a reference table

Dear PowerBi community, 

I would love to be able not to have to recreate each time the color scheme I need for some of my datas and to be able to reuse them for future analysis in New PowerBI.

Examples:

when I use my list of age group, I would like to have a specific color for each of them.

when I use a community list, I would like to specify for each of them a different color gradient depending on where they are situated etc.

I have a reference table for both of them, and I added a column with the color reference, but I am struggling in linking them with the fx (in fact, I don't even see the fx sometimes).

Does anyone already created reference colored table to get systematic coloring in their graphs? (or any other way to do it systematically :))

Could you tell me what's the best route to do it?

Thanks a lot for your help!

Nathalie