Stacked bar chart column colors changing after save

[hazeltine]

The colors of columns in my stacked bar charts keep changing after i save, close, and reopen the report, or when i publish to a workspace. I go in and fix the colors but they keep changing back to the wrong colors. 

[angela_h]

Hello,

I have a very similar problem. Even though I work with legends in my stacked bar charts as well as in pie charts, the colors constantly change after every reopening. Sometimes even the same color is used for two different categories. I need three colors for examination results (good = green / average = orange / insufficent = red) and set them in my color scheme as the first three colors. Since I cannot manage to solve the problem even when manually setting every category (over and over again), I wanted to work with a color mapping table but there is no fx-button where I could activate it. What other option do I have? Unfortunately the categroies do not really allow other colors...

[v-sdhruv]

Hi @hazeltine ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv · Accepted solution]

Hi @hazeltine ,
Power BI remembers and binds the color to the legend category when the legend is visible.

That’s why your visual with legend doesn't change colors — it's anchored.

For the Visuals without the legend showing, Power BI may forget or reassign colors across saves/refreshes if the legend isn’t visible, because it has no visual cue to tie the color to the category.

Even though it remembers your color palette, it doesn’t always remember which color went to which category, especially in stacked visuals.

That's why its recommended to keep your legend on.
Hope this helps!

If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you!

[bao_phan]

Are you using any conditional formatting ?

[hazeltine]

i added conditional columns to edit the legend order. strongly agree = 1, agree = 2, disagree = 3, then sorted by the number columns. i have another page in the same report that also has conditional columns to edit the legend order (same strongly agree = 1, agree = 2, disagree = 3), but that one doesn't change any colors when i save.

it seems like the visual with the legend showing doesn't change colors. it's supposed to be strongly agree = green, agree = blue, disagree = gold, but all the colors have been switching. it never switches to another color in the theme besides green, blue, or gold.

[amitchandak]

@hazeltine , color should not change unless values are changing. Are you using bookmarks on the page?

[hazeltine]

no, not using bookmarks

[amitchandak]

@hazeltine , if you are using the theme file, just download and upload it again. There are some changes related to the theme this month. Or just set the top color again from the theme and try out.
View- > Theme -> Customize theme