Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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)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
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 7 | |
| 4 | |
| 3 | |
| 3 |