Forum Discussion
Applying colour codes to a data set to apply to multiple graphs
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.
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.
3 Replies
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
V-lianl-msftCommunity Support
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.
