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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi All
I need to have the background of a visual ≈50% transparent this changes the color so that it doesn´t mach the other visuals.
Does anyone know if there is a way to sort this out?
/Måns
Solved! Go to Solution.
Hi @Anonymous
You can create a measure with below code
Measure = "rgba(0, 0, 0,0.5)"
Now use it as formula in your background color
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Can you please explain a bit more with screenshots
in the meantime you can change the transparency of background by going to properties of visual
Proud to be a Super User!
This two textboxes has the same color, but diffrent Transparency. Changing transparency in a visual changes the color. My issue is that I need to keep the color of my visuals matching but I also need to have Transparency at 50% for one of the visuals.
Maby some one knows how much 1% of transparency changes the color so I can compensat the hex or somthing?
For the testing of how much 1% compensates the RGB for Black(00000), I did test in Mspaint using a color picker for each transparent color..
It increases the value by 2.55 for each red, blue and green. But since you cannot put 2.5 in RGB format so it has to be 3 ,5,8,10 ... 25 for 10% .... and 255 for 100%.
Once you get the RGB Value for your color you can easily convert it to HEXA
RGB to Hex color converter (rapidtables.com)
Proud to be a Super User!
Hi @Anonymous
You can create a measure with below code
Measure = "rgba(0, 0, 0,0.5)"
Now use it as formula in your background color
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Ok @Samarth_18 you´r solution works if i add the measure to the dataset that I´m connected to but not if I build the measure in the report.
So my problem are solved, thanks a bunch 👍
Intressting, but I don´t understand were/how to use it as a formula in the background color. I´ve tride fx and use the messure there?
Yes just click on the "FX" of the background option for the visual which you want to change:-
and select measure as field value
Note:- You can pass your RGB color accordingly and for transparency you can pass value at last. Like i have mentioned 0.5 for 50%.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
I clearly I´m missing something, can´t hit ok here. meassure is exat copy of yours.
Click on "TEST color " then click "OK"
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Well I´m not that inept, 😂
Clicking "TEST color" is not possible.
Looking att you screenshoot Your´s just say Color over "format by"
My says Color - Background
Maby I´m in the wrong place?
I clicked fx under background for visual
You are changing background of text box right?if yes then it will work there also.
Can you please share PBIX after removing sensitive data?
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Ok, I´m in direct querry for this one so I can´t . But when I tested it in an import repport you´re trick works like a charm.
Maby it´s the direct querry that´s spoiling the fun, I´ll look in to that and get back.
By the way @Samarth_18 thanks for all the help 🙏