Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
BuistJF
Helper I
Helper I

Make a table or matrix transparent

I can see previous posts showing how to do this but using historic versions of PBI. Is it still possible to make a table or matrix transparent. I've tried switching background of and setting style present to None but its not giving me what I want, outcome below:

BuistJF_0-1670582315736.png

I want the column headers and all value fields to be transparent.

Cheers for your help in advance.

 

1 ACCEPTED SOLUTION
VijayP
Super User
Super User

@BuistJF 

It is possible . You need to change the Table preset to None. Follow the snapshot attached

VijayP_0-1670582837379.png

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


View solution in original post

14 REPLIES 14
Banthos
Frequent Visitor

Can anyone advise if this works in Feb 2024 Power BI Desktop. I'm too many hours into attemtping to get a transparent table that in past versions took all of 1 minute.

THe details as listed no longer show up on the latest version. Any guidance? Thanks 

Syndicate_Admin
Administrator
Administrator

That was the solution, thank you very much.

Syndicate_Admin
Administrator
Administrator

Thank you

VijayP
Super User
Super User

@BuistJF 

If it is custom Theme you can still change background color to transparent

VijayP_0-1670584717004.png

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Hi @VijayP I am trying to make the background color of my table/matrix visual transparent but so far no luck. I have a custom theme so followed your instructions above (Style preset to None and 100% transparency in Customize theme/Visuals/Background) but this doesn't make the background transparent. Would you have any other suggestions?

 

@PunchBird 

VijayP_2-1682489017428.png

 

VijayP_1-1682488955397.png

 

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Even in the Custom theme there is an option of Visual background that should be made transparent




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


@VijayP  thanks - I already tried this but the table and matrix visual don't become transparent. It seems to be caused by something else in my custom theme. When I try with a default theme, it works.

BuistJF
Helper I
Helper I

I believe its because I'm using a custom theme and therefore not able to achieve what I need, would you think this is the cause. I have tried adjusting the custom theme but PBI wont allow me to re-set to default, may need to re-build custom theme.

VijayP
Super User
Super User

@BuistJF 

It is not color , It is preset, Check the option of Preset as shown in the picture




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


VijayP
Super User
Super User

@BuistJF 

It is possible . You need to change the Table preset to None. Follow the snapshot attached

VijayP_0-1670582837379.png

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


I've found you also need to go to the General pane (of the visual settings) and ensure that Background is set to Off.

Bilbo_777_0-1717768136990.png

 

I have been looking for this type of answer forever - so simple!

 

But why on earth have MS 'hidden' this option and not made it so, directly in all of the background color options no matter the type of visual, blooddy annoying.

Thank you for this quick response but I dont have an option to select 'no value' for background colour, see below: 

BuistJF_0-1670583227939.png

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.