Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
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.
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
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |