Forum Discussion

WSD's avatar
WSD
Frequent Visitor
1 year ago
Solved

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)


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. 

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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:

    Microsoft Idea

    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.

4 Replies

    • WSD's avatar
      WSD
      Frequent Visitor
      1 year ago

      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's avatar
        Anonymous
        Not applicable
        1 year ago

        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:

        Microsoft Idea

        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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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