Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
WSD
Frequent Visitor

Consistent Legend Color across report

Hi there
I have a question, regarding formating in my report. 
Lets say i have a line chart like this. (Source)

power-bi-line-charts
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. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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:

vlinyulumsft_0-1739771513709.png

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:

vlinyulumsft_1-1739771513710.png

Microsoft Idea

vlinyulumsft_2-1739771552313.png

Microsoft Idea

 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.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

PijushRoy
Super User
Super User

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





Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





WSD
Frequent Visitor

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?

Anonymous
Not applicable

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:

vlinyulumsft_0-1739771513709.png

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:

vlinyulumsft_1-1739771513710.png

Microsoft Idea

vlinyulumsft_2-1739771552313.png

Microsoft Idea

 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.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.