Forum Discussion

Crydus's avatar
Crydus
Icon for Helper I rankHelper I
6 years ago
Solved

Fix colors in dynamic stacked chart

Hello,  currently I am working on a quality report for my company and here I have a problem with the colors.  I want to create a clustered stacked chart where I can see the amount of claims per...
Need Help
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Crydus , Conditional formatting is nor supported on the stacked . You can try to give hard-coded color bu that will change with filters

 

 

vote for idea or log new one -https://ideas.powerbi.com/ideas/

  • Crydus's avatar
    Crydus
    Icon for Helper I rankHelper I
    6 years ago

    Okay, then I have to find a workaround to this problem. 
    My hope was, that there is a solution to this, hopefully something like this will be added in the future. 

    Thank you! 

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hello @Crydus ,

      By design, colors are assigned to dynamic values on a first-come, first-served basis. Charging time can affect this.

      If you use the legend field, conditional formatting will not work.

      Choose one of the two to see which one is better.

      You clould also vote for this idea.

      Best regards
      Liang
      If this post helps, then consider Accept it as the solution to help other members find it faster.

      • Crydus's avatar
        Crydus
        Icon for Helper I rankHelper I
        6 years ago

        Thank you, for your answer. 
        I need the stacked chart, as we need to show the distribution per month.. 

        In general this shouldn't be a problem, as the theme colors should be used but Power BI seems to struggle with customized colors and themes, hopefully this will be fixed in the future. 
        As for now, it seems that the data set is "choosing" the colors starting with 01.2020, so from Janurary 2020 to August 2020 the colors are fine, and from there onward the colors shift to the wrong palette, I don't know why Power BI chooses January 2020 as starting point, but I assumed that it does so because 2020 is the current year. If that is true, the problem won't be that big, but I don't know. 

        Best regards, 

        Tobias