topic Python in Power BI - Set background colour for matplotlib box plot in Developer

Python in Power BI - Set background colour for matplotlib box plot

dpc_development — Tue, 16 Apr 2019 03:02:03 GMT

I am plotting a box plot using Python in Power BI. I have set the background colour of the Power BI report page to yellow and am trying to set the background colour of the python visual. I have the following code currently.

matplotlib.rc('axes', facecolor = 'red')
dataset.boxplot(column='daily_return', by='name', grid=False, figsize=(15,4))
matplotlib.pyplot.title('')
matplotlib.pyplot.suptitle('')
matplotlib.pyplot.xlabel('')
matplotlib.pyplot.show()

The above code results in the following picture...

As can be seen, there is still some white space. How do I get that to be red, which I will eventually change to my Power BI background colour.

If I can make the background transparent though, that'd be best.

I even tried the following to no avail.

fig = matplotlib.pyplot.figure()
fig.patch.set_facecolor('blue')
fig.patch.set_alpha(1)

Re: Python in Power BI - Set background colour for matplotlib box plot

lvcoffman — Tue, 07 May 2019 13:02:07 GMT

I'm having the exact same issue! I am putting together a demo for my team, and I would like to make the "sky" blue, but cannot for the life of me figure out how to turn the white boarder blue (or transparent as OP stated.)

I have tried setting the figure facecolor and edgecolor to blue:

fig1 = plt.figure(1,facecolor='#7ec0ee', edgecolor='#7ec0ee') <- This did nothing

ax = fig1.add_subplot(1,1,1)

ax.set_facecolor('#7ec0ee') <- this worked

These seem to work in Spyder, but when I put the visual into Power BI the white boarder appears.

Re: Python in Power BI - Set background colour for matplotlib box plot

Anonymous — Fri, 13 Jan 2023 12:42:53 GMT

Set the default matplotlib saving option to transperent like this:

import maplotlib matplotlib.rc('savefig', transperent=True)

This worked for me.

I got this answer from this https://stackoverflow.com/a/55746288/6819442