Forum Discussion
Data colors changing once published to web?
- 8 years ago
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 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.
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 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.
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:
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.
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.
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.
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.
- emiliano-a1 year agoRegular Visitor
Hi, this does not solve the issue.
I've cleared the caché, deleted the report and re uploaded it, and the issue remains:Desktop / Online:
The only real solution is re-mapping every color online?
I hate it. It's so uneffficient spending hours doing that.