topic Re: Data Colours change in Power BI Service in Service

Data Colours change in Power BI Service

Anonymous — Thu, 27 Apr 2017 07:03:24 GMT

Hi,

I find my a particular bar graph in my Power BI desktop has the data colour as Blue. After publishing to the service, the data colour changes to maroon. Tried everything.. doesn't seem to remain blue. How to fix this? Is there a bug?

Thanks,

Aasheesh

Re: Data Colours change in Power BI Service

Anonymous — Fri, 28 Apr 2017 05:55:21 GMT

Hi Anonymous,

Which visual you use? Can you share some detail content about this issue?

Regards,

Xiaoxin Sheng

Re: Data Colours change in Power BI Service

Anonymous — Fri, 28 Apr 2017 08:01:27 GMT

hi Anonymous,

I am using a normal stacked column chart. the second visualisation icon in the power bi desktop.

The column is coloured in blue (colour code - 008AFF) in my power BI desktop.. but when i publish it to power BI Service the same column changes to maroon with the same colour code.

Re: Data Colours change in Power BI Service

Anonymous — Tue, 02 May 2017 07:33:37 GMT

Hi Anonymous,

I can't reproduce your issue, it works on my side.(the custom color not changed, other color has changed)

Which version of power bi desktop you used? If you re-publish a report with sample content, does this issue appears again?

My test environment: Win10 64bit, power bi Version: 2.45.4704.442 64-bit (April 2017).

Regards,

Xiaoxin Sheng

Re: Data Colours change in Power BI Service

Anonymous — Tue, 02 May 2017 14:06:07 GMT

I created an issue about this yesterday. There seems to be a bug in the service.

Re: Data Colours change in Power BI Service

Anonymous — Tue, 02 May 2017 14:07:20 GMT

Anonymous Try it with bars that have only a single color/value.

Re: Data Colours change in Power BI Service

Anonymous — Thu, 04 May 2017 12:01:48 GMT

I can reproduce and confirm this issue occurs when published with one value.

As an additional issue it is now also not possible to use a color other than the standard color (with a single value) in Power BI desktop with the latest update (May 2017).

I have created a workaround by adding a dummy value in order to use more than one value.

Re: Data Colours change in Power BI Service

Anonymous — Fri, 05 May 2017 08:11:06 GMT

Anonymous, Anonymous,

I used a work around by adding multiple values and then changing the default colour to the colour i wanted and then removing the multiple values. It works.

Thanks for all your inputs.

Re: Data Colours change in Power BI Service

denveroed — Wed, 15 Aug 2018 01:09:25 GMT

This bug seems to be back and it's killing me!

My bar chart and pie chart colors change when I publish to the web, and my image file is missing completely.

Help!!!

Re: Data Colours change in Power BI Service

doyleg_OEH — Thu, 16 Aug 2018 00:26:55 GMT

I had the same issue with custom colours set in the Desktop then changing upon publishing to the service. I am pretty sure I used Format Painter to apply the colours to a new visual from an exisiting one with the correct pallette, so I think this was the cause in my case.

My fix was to go into each colour and open the custom colour dialogue, delete the last character of the hex string and then immediatly replace it (tricked it into thinking there was a colour change) and hit enter. Had to do this for each colour in each new visual but it stuck upon publishing to the service.

Cheers

Gavin

Re: Data Colours change in Power BI Service

harin — Sat, 29 Sep 2018 05:21:37 GMT

I do see similar issue when I publish the report. I have pie chart and clustered bar chart with multiple values, I manually edited the color in clustered bar chart to sync with pie chart. Once I deploy this report these changes are gone. This there any work around for this issue?

Re: Data Colours change in Power BI Service

rkozlowski — Fri, 12 Oct 2018 19:30:37 GMT

I'm also having a similar issue. I have a line chart with 8 lines. Each line is a unique color. Once the report is published the chart color formatting is changed and two of the 8 lines are the same color. The chart reverts back to the desired color formatting from my power bi desktop file after refreshing the browser. It would be much more convinient if I didn't have to tell my end users they need to refresh their browser upon opening my report.

Re: Data Colours change in Power BI Service

Anonymous — Fri, 12 Oct 2018 20:03:27 GMT

Use sample data and set a color once you set the color remove the sample data and when the original data shows up you will be seeing the color which you set for the sample data. It will remain the same even after publishing.

Re: Data Colours change in Power BI Service

nsc — Mon, 15 Oct 2018 07:52:58 GMT

Recently had a flash back of the changing color issue in the service also, however this time it was just for a single report, so I suspect that report had either been altered at some point or perhaps had used an older version of Pbi desktop. All other reports that use the same theme was working fine... Reapplying the custom theme and publishing again fixed all visuals....

Re: Data Colours change in Power BI Service

Anonymous — Wed, 26 Feb 2020 16:03:34 GMT

Just wanted to say that the trick of "changing" the last char of the color code worked for me (for now).

Re: Data Colours change in Power BI Service

Anonymous — Wed, 11 Mar 2020 15:33:16 GMT

I've just had this same issue - very annoying because my end user needed to notify me about many of my custom colours changing to yellow, making my report unreadable! Retyping the last digit of the colour code fixed it, for the colours that autochanged in the service. This is an embarrassing error, and I hope it can be fixed soon.

Re: Data Colours change in Power BI Service

Anonymous — Mon, 08 Jun 2020 10:13:18 GMT

Hi,

I've been publishing a report for a while now and I just published the last refreshed version and the colours have changed. I tried changing the colours both in the desktop version and online and once I publish they revert back to random colours. It's only 1 visual (line chart with multiple lines) so far affected. Nothing has resolved the issue. This report uses colour references thorughout various tables and other charts so I really need to fix it. Please help!

Re: Data Colours change in Power BI Service

cv_01 — Mon, 08 Jun 2020 14:59:34 GMT

I am experiencing the same issue. Colors displayed in the service is different than the desktop version after publishing. Seems to have changed this weekend.

Re: Data Colours change in Power BI Service

Anonymous — Mon, 08 Jun 2020 15:07:46 GMT

I just tried republishing the original report that I created this thread for, and the colours are working fine. cv_01 , Anonymous , have you tried 'modifying' the colours by opening the Custom Color box, and just deleting & retyping the last character of the hexadecimal colour code? It updates something inside of Power BI, and is what fixed the issue for me originally.

Re: Data Colours change in Power BI Service

Anonymous — Mon, 08 Jun 2020 16:04:44 GMT

Hi Anonymous thanks for your reply. I tried that and also changing completely the colour on the desktop version and also online but not luck with it. 😞