Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi there
I have a question, regarding formating in my report.
Lets say i have a line chart like this. (Source)
And i would like to set color values for each line, based on the value for manufacturer, as i would like to use their corperate colors throughout my report, without having to go into each and every visual and change the colors manually.
Is there a way to achieve this?
Also in a way, that the colors will stay consistent, if i only look at a subset.
So far I have experimented with the report theme, but i see no way of actually saying something like
Fama = #008000
I would greatly appreciate help here.
Solved! Go to Solution.
Thanks for the reply from PijushRoy , please allow me to provide another insight:
Hi, @WSD
Thanks for reaching out to the Microsoft fabric community forum.
As of now, as you are aware, we can only change the color of data points by manually setting conditional formatting for each visual object. In other words, each new visual object requires you to manually set the conditional formatting. Themes defined using JSON files do not support unified color configuration for data points.
Currently, the most effective alternative is still to manually set the conditional formatting. Below are screenshots of the relevant documentation:
For more details, please refer to:
Tips and tricks for formatting in reports - Power BI | Microsoft Learn
Here is some documentation on designing global colors, which might help you consider other alternatives:
Power BI Theme Generators - Microsoft Fabric Community
You can also try using PBIT template files, but they have strict requirements for your data structure.
Create and use report templates in Power BI Desktop - Power BI | Microsoft Learn
If you feel that performance improvements are needed, you can vote on the https://ideas.fabric.microsoft.com/platform. Below are screenshots and links of similar ideas:
This allows other users with the same needs to vote for similar ideas, helping to accelerate their implementation. Many features of our existing products are designed and upgraded based on customer feedback. As demand increases, this issue may be resolved in the future.
Thanks for your understanding.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,@WSD
I am glad that my answer could help you, and I appreciate you accepting my answer as the solution. This recognition of my efforts also helps others in the community with similar issues find solutions more quickly.
If you encounter any problems in the future, feel free to share them again.
Have a great day!
Best Regards,
Leroy Lu
Hi @WSD
Yes, please use the Theme option
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes
https://www.youtube.com/watch?v=TctLf7SwPk0
Proud to be a Super User! | |
This does not help me define the exact colors that i need, depending on the legend.
As Color 1 - 9 does not give me exact controll over which number is going to be used for which of the labels in the legend.
Let's say for example, that i have companies [AAA, BBB, CCC] and i want them to be in the colores [RED, GREEN, BLUE].
But i also have different visuals, where i need the primary colors to be [AMBER, ORANGE, PURPLE], while not relying on the companies, but maybe the urgencies of order delivery times. Now my theme would still start with the first colors defined in my theme, right?
Thanks for the reply from PijushRoy , please allow me to provide another insight:
Hi, @WSD
Thanks for reaching out to the Microsoft fabric community forum.
As of now, as you are aware, we can only change the color of data points by manually setting conditional formatting for each visual object. In other words, each new visual object requires you to manually set the conditional formatting. Themes defined using JSON files do not support unified color configuration for data points.
Currently, the most effective alternative is still to manually set the conditional formatting. Below are screenshots of the relevant documentation:
For more details, please refer to:
Tips and tricks for formatting in reports - Power BI | Microsoft Learn
Here is some documentation on designing global colors, which might help you consider other alternatives:
Power BI Theme Generators - Microsoft Fabric Community
You can also try using PBIT template files, but they have strict requirements for your data structure.
Create and use report templates in Power BI Desktop - Power BI | Microsoft Learn
If you feel that performance improvements are needed, you can vote on the https://ideas.fabric.microsoft.com/platform. Below are screenshots and links of similar ideas:
This allows other users with the same needs to vote for similar ideas, helping to accelerate their implementation. Many features of our existing products are designed and upgraded based on customer feedback. As demand increases, this issue may be resolved in the future.
Thanks for your understanding.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.