Visualization Colors changing when publishing to web?

[Anonymous]

Hi Power Bi Community,

I've build a report in Power Bi Desktop which has been published to my workspace. When viewing the report in my workspace the colors are coming through fine. However when I publish to Web the colors change. I did create a json custom template theme for desktop but I'm not sure that is the issue because the colors are fine in my app.powerbi workspace, it's only when I create an embed code that it goes funky. I've found this similar example which is marked as solved but am not seeing a solution there (https://community.powerbi.com/t5/Service/Data-colors-changing-once-published-to-web/m-p/322416#M3690...)

The colors that I've manually changed seem to be pulling through fine, but the ones that I let the custom theme "do the work" it pulls funky colors (pink, teal - probably the native colors?)

The published version is also not pulling the custom image I have on each page (the company logo) but it shows up fine in my workspace.

Any ideas or solutions? Thanks in advance!

[jacksonfan]

Microsoft has acknowledged the issue of Power BI colors changing when reports are published from Power BI Desktop to the web service. However, they have not provided a permanent fix as of the latest reports.

Step-by-Step Guide for New Users:

1. Clear Cache on Power BI Desktop:

   • Open Power BI Desktop.

   • Navigate to the File menu in the top-left corner.

   • Go to Options and settings and select Options.

   • In the left-hand menu under Global, click on Data Load.

   • Find the option Clear cache and click on it to clear the cache data from Power BI Desktop.

2. Delete the Original Report from Power BI Service:

   • Open your web browser and log in to the Power BI Service

   • In the Workspace where your report is located, find the report you want to delete.

   • Select the report, click the More options (three dots) next to the report name, and choose Delete.

   • Confirm the deletion when prompted.

3. Re-upload the Correct color Report to Power BI Service:

   • Go back to Power BI Desktop.

   • After clearing the cache, re-open your report or ensure the latest version is open.

   • Click on Publish in the top-right corner of the Power BI Desktop window.

   • Select the appropriate Workspace in Power BI Service and click Select to upload the report again.

4. Verify the Fix:

   • Once the report is re-uploaded, go to the Power BI Service in your web browser.

   • Check the colors in the visuals to ensure they now match the colors seen in Power BI Desktop.

This should resolve the color differences between the Power BI Desktop and Power BI Service.

[dforcato]

Still happening in 2024?? And they pretend to spend $10 per month for a product that cant respect user colors???

[Samoe]

It's March 2023, I have this issue constantly 😕 Has anyone found a permanent and easy fix? For me it's the default colours in the default theme, and they randomnly change! Also I cannot set the colours manually as we are talking about too many entries here... this would be a huge pain.

[watts_jim]

Save the theme, then reload it, then publish.  It has worked for me - so far !

[BCP_Caterpillar]

Color's changing when publishing charts is still happening 12/2022

[HLandry73]

This just happened to me AGAIN.  As pointed out above, this has been an issue for several years.  I have not seen a response from a MS representative, are they even working to resolve this issue?  As mentioned this is a major pain.  

[rvadnai]

Hello, 

It's 5/12/2022 and colors in my 6 months-old reports in Power Service changed overnight!  It is a huge problem.  Please re-open this issue and try to solve it.  The report is an internal Microsoft report and I would be glad to share its address with a Power BI SME at Microsoft.

Thank you!

[Data-Bit]

It's 2022 and this issue still hapenning!

[froy]

Hi!

I am fighting against the same problem... and it's Jun/2020 !!

I am not even using a personalized theme... I am experiencing this problem while using one of the default PBI themes...

please, a solution is needed!!

[jrfigueroa]

June 2020 is here and still hapenning the issue...

[Simm3r]

April 2020 is here and I also am still having this issue. Any updates on the root cause and how we can resolve please? (besides the already listed options).

[dangelo1]

Hey,

2020 is here, this issue still exists...When can we expect a fix?

Best regards,

Dimitar

[Anonymous]

I have managed to resolve this issue, it was driving me crazy for a long time. In Desktop, go to the Data Colors properties for the relevant chart that is changing colors/incorrect, then click on Revert to Default. Publish the report and the colors should be consistent. 

[fish3101]

Unfortunately this is not a viable solution for me....I don't want to revert to default if I have deliberately set colours that deviate from the default.

[Anonymous]

Just to clarify, my solution was when using a JSON theme to derive the Data Colours. You will not want to "Revert to Default" when you are manually selecting the colours in your case.

[garythomann]

... sometimes just have to manually change the colours in the service and pretend the publish worked!

Last incident, have a report with 4 pages, 2 pages published with custom colours correctly and 2 did not.

[Anonymous]

Still there is a problem. Colors changing when published. However, when I go back to the BI Desktop and change the colors manually and publish it again then it fixes the issue. Hope this helps

[Anonymous]

Nope. Still happens every few times I publish something and then I need to go back into the report and manually change each color.

[fish3101]

This is still not resolved.

This is definately a bug that I have experienced for over a year or more and I have not been able to find a permanent fix. Definately not a 'working as designed' issue. The problem seems to rear it's ugly head when you apply custom colours to a chart, rather than letting it default select. What's more, after it's been published to service, if I hit F5 to refresh the page, the colours keep cycling around randomly. There seems to be a workaround where you can manually type in the HEX value of the colour (or delete the last character of the HEX and re-type again, essentially tricking it to think something has changed), then on re-publish the colours seem to stick. This is a pain and defeats the purpose of having a custom theme file imported. Please find a fix for this as it's extremely painful and time consuming to fix manually on every visualisation.

[Anonymous]

Hi everyone, I am pleased to report that Microsoft engineers have indeed fixed the problem, and I've been told it was resolved at service level and would apply to all users.