Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JD0963
Helper I
Helper I

Data colors changing once published to web?

Hi, I have some visuals on my report which use the correct color in PowerBI desktop, however when I publish to the web these colors revert back to the default teal color. Any reason why? I am using bar chart visuals..

 

I have tried the fix (where people suggest adding values to the axis and then re-selecting the default color) however this doesn't work.

 

I also have the word cloud custom visual which is resetting to the default multicolored appearance after publishing.

 

Does anyone know why this might be? I am using the latest version of PowerBI (November)

 

Thank you

 

1 ACCEPTED SOLUTION
jrw0712
New Member

I'm also getting this when I publish from the desktop to the web and can't find a way to get it to stop. I upgarded this past weekend to the November update.

 

For some reason, off track will change from red to teal when I publish it to the web. What looks like the legend is actually a different visualization then the gantt chart (slicer) with only the legend showing so that when I click on them, only the selected status' show in the gantt chart instead of them being greyed out if you were to use the gantt legend.

 

Power BI Desktop screenshot. Notice Off Track is red in slicer Legend and red in the gantt chart

Power BI Desktop screenshot.jpg

Power BI Workspace/Published to web view. Off Track changes to teal in the Legend. You'll notice that the gantt stays the same because as I mentioned they're acutally two different visualizations. 

Power BI Web workspace screenshot.jpg 

View solution in original post

9 REPLIES 9
OneWithQuestion
Post Prodigy
Post Prodigy

How is this STILL a problem... it STILL happens with column charts too...

Why does this clear error in software still exist over 5 years later?

sebbayard
Helper I
Helper I

Hi all, 

have the same problem here, the report is actually reverting back to the custom theme after you make changes to the report. 

It looks fine in PBI service, but the public URL is formatted with the default PBI theme 😞

 

A workaround sofar that is actually working is to upload the report and use it as template, and then make a copy of it and publish to web. Sofar the copy of the original works perfectly fine after making updates/ changes in the report.

To edit a report in PBI service is not always optimal though - you might need to insert an image and that can only be done in desktope for instance. 

 

However, hope this can help.

I really hope this issue will be adressed soon and resolved. 

 

Thanks

Ben

Pardon moi, could you be more detailed about the procedure? 😅 
How/where could I "make a copy"? 
This issue is very frustrating... 😥

Ah of course.  Edit the report and save as a new one in PBI service. 
Then publish to web 😊

 

jrw0712
New Member

I'm also getting this when I publish from the desktop to the web and can't find a way to get it to stop. I upgarded this past weekend to the November update.

 

For some reason, off track will change from red to teal when I publish it to the web. What looks like the legend is actually a different visualization then the gantt chart (slicer) with only the legend showing so that when I click on them, only the selected status' show in the gantt chart instead of them being greyed out if you were to use the gantt legend.

 

Power BI Desktop screenshot. Notice Off Track is red in slicer Legend and red in the gantt chart

Power BI Desktop screenshot.jpg

Power BI Workspace/Published to web view. Off Track changes to teal in the Legend. You'll notice that the gantt stays the same because as I mentioned they're acutally two different visualizations. 

Power BI Web workspace screenshot.jpg 

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.

Hi guys,

I do not see a solution to this problem, have you found any?

 

Best regards,

Dimitar 

Also, getting this issue in Pie Charts, is there a fix for this yet?

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors