So I've noticed that on several occasions when I publish a report to a group, the colors within a visualization will change to something other than what I set them to be. I've specifically noticed these on line and bar charts.
I try not to change any colors in a visualization from what is set automatically by Power BI. But there have been times where I need to make a change to the automatted selected colors (still keeping within the spectrum of colors available in the default Power BI listing). When I publish the report, the colors that were modified will sometimes change. I have to edit the published report by hand to change some of the colors back to what they were in the desktop file.
Any suggestions on a fix, would be great. It seems like there's a bug that doesn't allow colors to stay "locked in" when reports are published.
I'm curious to know if others have encountered this.
Chooses to, you really hope Microsoft CHOOSES to fix this bug.... it's been a bug for a LONG time... with no resolution yet 😞
I am experiencing this as well! It's very frustrating and completely random, my company has a specific palette I need to adhere to and this is going to get me into trouble if I can't find a work around.
Please fix this!!
What helped in my case was to change the colors to something. Different. I am not sure if it will stick if I change the colors back... I forgot what the original colors were.
I have this issue as well. I want several pages in a report to have the same color scheme, and have specified colors to a small dimension. Some of the colors change when deployed but not all.
I use SSAS as the data source.
I have had this same issue, at least with pie and line charts.
This is frustrating especially with a line chart where I have a number of lines and made an effort to differientate the colors. After publishing, some line colors change to different ones compared to the colors they were defined on the desktop version.
Here's some details how the colors have changed:
My collegue complained that some colors are too close to each other. The dashboard showed wrong colors with firefox, chrome and ie browsers.
On my computer the colors were fine for a while with firefox and ie. After using the published dashboard the colors changed.
I'd like to see this bug fixed.
I'm also experiencing this bug in a pie chart. I have legend of 10 colors and I want 2 colors to be the same, but in the PBI service it changes the wrong ones.
Re-applying all the colors to the items seems to have fixed the issue, but I don't know for how long..
Can anybody reproduce this?
I have this issue and it is causing serious problems as we have standard color coding we use for given categories.... now they are changing at random.
Have you tried the workaround above? Workaround: Add some data to your chart's Axis. Set the color, then remove the data from the Axis field.
This might be able to help while Microsoft works to fix the issue.
Yeah, it did not seem to work sadly....
EDIT: I should have clarified, this is happening with pie charts and Treemaps as well.
I experienced this, as well. My forum post about is here. Forum user @StewartR noted that it seems to happen for charts that don't have an axis. StewartR also provided a workaround if you are unable to modify the charts (I noticed that for some of my charts, I couldn't change the wrong color once it was published to the Power BI service).
Workaround: Add some data to your chart's Axis. Set the color, then remove the data from the Axis field.
I'm using Zoomcharts Donut Chart and publishing is changing the color to white, making the fraction obscure.
OneWithQuestion (below) also mentions using Pie Charts and TreeMaps.
Hoping to figure this out soon.
Thanks for your guidance.
I changed the color from a custom looking color to a more common color and it worked for the first level donut filter, but changed a color in the 3rd level to white.
Changed the deep red custom color to a tannish (light brown/grey) color and it worked - the colors in the published report were the same as the colors in the desktop report (Zoomcharts Donut Chart).
I experienced this for the first time today. I went back into the desktop version and re-selected all of the data colors in one of the charts. Then I republished and the colors appeared correctly in the chart where I reselected the colors and incorrectly in the other chart. Then I did the same for the other chart and republished again and all the colors appeared correctly. This does appear to be a bug. Fortunately I did not have a lot of colors and charts to reselect so this workaround appears to have worked for me pretty easily.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.