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 man...
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.

  • 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.