Colors in visuals change after publishing to web service (any json gurus?)

[Anonymous]

Hello Community  -  I have experienced this issue many times and finally think I stumbled upon the answer.    I am indeed using a custom them from Power Bi tips and tricks.    Using their tool, I generated a custom them according to our company branding.  

It appears based on another thread here in the forums that this could be the cause of my issue....which is that my visuals sometimes change colors when they get published.   It's very annoying.  

In the thread, the answer talks about not using "triple wildcards".    I have no idea about json.    But here is the code.    If anyone out there knows how this code could possibly be improved to avoid the "triple wildcard" issue....please help!   

{
  "name": "MyTheme",
  "dataColors": [
    "#364652",
    "#ff6600",
    "#85b5ba",
    "#f4faff"
  ],
  "visualStyles": {
    "*": {
      "*": {
        "*": [
          {
            "color": {
              "solid": {}
            }
          }
        ]
      }
    }
  }
}

[mwegener · Accepted solution]

Hi @Anonymous,

try this.

{
  "name": "MyTheme",
  "dataColors": [
    "#364652",
    "#ff6600",
    "#85b5ba",
    "#f4faff"
  ]
}

[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.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

I just tested on my side and it works fine. Kindly mark sure you're using the latest desktop version.

here're some similar threads could be your reference:

https://community.powerbi.com/t5/Service/Colours-Change-when-report-is-published-to-the-Service/td-p/399083 

workaround provided:

https://community.powerbi.com/t5/Service/Data-Colours-change-in-Power-BI-Service/m-p/165403 

[mwegener · Accepted solution]

Hi @Anonymous,

try this.

{
  "name": "MyTheme",
  "dataColors": [
    "#364652",
    "#ff6600",
    "#85b5ba",
    "#f4faff"
  ]
}