Forum Discussion
Helper IFix colors in dynamic stacked chart
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/
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.
Super UserCrydus , 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/
Helper IOkay, 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-msftCommunity Support
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
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