cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aasheesh1
Advocate II
Advocate II

Data Colours change in Power BI Service

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

1 ACCEPTED SOLUTION

@Anonymous, @v-shex-msft,

 

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.

View solution in original post

36 REPLIES 36
JackAttack
New Member

Continue to have this issue myself - even across two charts on the same page using the same dimension for the Legend.

vinS
Advocate II
Advocate II

When you pin the visual make sure you select the correct theme option.

jmagnan
Regular Visitor

We are still experiencing this issue, but appears to only be certain users in our organization. Its fine for some users and incorrect for others, we have closed and re-opened browsers as well. We will test the suggested options and see if that helps.

Tested the workarounds with no luck, I've opened a support ticket.

Anonymous
Not applicable

Hi y'all!

 

I am still facing this issue with a line chart.

 

Tried everything, including, rebuilding the report, changing the last HEX character, nothing seems to work for me.

 

 

Anonymous
Not applicable

@Anonymous Yes same is the scenerio in my case.
Just need to wait maybe for some fix by microsoft

Hi all, @Anonymous @aasheesh1 @Anonymous @cv_01 @mecho Update!

 

Today without any additional work (not even refreshing the dataset), my reports appeared with the right colours. It looks like there was a bug which was sorted by Microsoft on the background. I'll keep an eye anyway as it may appear again. I hope yours are fixed as well in the coming hours but let me know.

 

Kind regards,

 

NDE 

NDE
Helper I
Helper I

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!  

cv_01
Frequent Visitor

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. 

I just tried republishing the original report that I created this thread for, and the colours are working fine. @cv_01@NDE , 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.

Hi @mecho 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. 😞

 

 

Anonymous
Not applicable

Yes, it is really frustrating now for the customers as well, as it represents their brand, and this bug is creating a lot of problem internally in the organization, workaround works for some but not for all, we need a solution to it which I think Microsoft has been ignoring since 2017. This issue is consistent from past so many years and no solution to a bug with workarounds involving lot of extra time and efforts.

Please tell us what to do avoid such a things going forward.

 

Anonymous
Not applicable

Hello All,

 

I raised the ticket with Microsoft the very same day and they were really very helpful to fix the issue quickly.
Thanks to Venkata from Microsoft support team to help on this.

Regarding the problem description there was Regression Issue which has been fixed by the new code in the backend. It's a bug from the Line visual which has been fixed by the product group in the new code.

 

Let me know if it is working for everyone now.

Hi @Anonymous,

 

Great news to hear the issue has been found and resolved! Thanks for raising it directly with Microsoft. 🙂

 

It has been workign for me now, not sure about the others @aasheesh1 @jmagnan @Anonymous @cv_01  ?

 

Kind regards, NDE

jmagnan
Regular Visitor

I have one user saying the issue resolved and waiting to hear from the other, but sounds like this solved it. Thanks!

I have actually JUST experienced this problem again. I upload one of my reports to multiple workspaces. When I did so yesterday, my report had different combinations of colours in every single workspace! When I opened my .pbix again and manually changed the last digit of the colour code and reuploaded, it finally changed all three workspaces into the same colour.

Anonymous
Not applicable

Hopefully it did be same now going forward, if not we can always raise a ticket and walk through to the problem.

Keep us updated if that issue persist.

 

@NDEI tried republishing my report yet again but didn't expeience the issue. This seems to be a report-level issue; but still, I'm not sure what the resolution is.

cv_01
Frequent Visitor

I was able to address this issue by recreating the charts in my report. This is one of my older reports, maybe active since 2018. Trying a few different things I have noticed that if I switched the charts, I could keep the colors. Ultimately I had to delete the line chart and redo it. My guess is that something in the line chart didn't compute with whatever new released and caused the confusion. Also my other newer reports with line charts didn't have this issue. Deleting and redoing the chart, at least for me, solved the issue. 

santoshvarma
Frequent Visitor

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.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!