Applying colour codes to a data set to apply to multiple graphs

[Anonymous]

As a newer user of Power BI i am have multiple charts showing data for a number sales products.  I want to apply a corporate colour for each product so that it is the same on every graph.  I know how to do this individually chart by chart but there must be a better way to do this, but cant work out how to do it.  I already have hex colour codes etc.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You can create a measure and apply it to the conditional formatting of the data color.

Measure = SWITCH(TRUE(),
                MAX('Table'[Product])="A","RED",
                MAX('Table'[Product])="B","LIME",
                MAX('Table'[Product])="C","YELLOW",
                MAX('Table'[Product])="D","GREEN",
                MAX('Table'[Product])="E","GREY",
                MAX('Table'[Product])="F","BLACK",
                MAX('Table'[Product])="G","PINK",
                "BLUE"
)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Try :  https://www.archerpoint.com/blog/Posts/how-set-custom-color-themes-microsoft-power-bi

https://docs.microsoft.com/en-us/power-bi/desktop-report-themes

[Anonymous]

Not sure this answers my question.  I am not trying to change the background and foreground but define what is in my data as "Products" with set colours in a graph and i have around 20 products.  So if a product is called Product "A" i always want the graph to show a set colour and if Product "B" another colour.  How do you define for each product the exact colour to want applied.  Thanks