Report backgrounds and images in Power BI - Cell-by-Cell Formula Trace

Sample Data

This data shows report pages with their assigned background images and transparency levels.

Cell	Value
A1	Page
B1	Background Image
C1	Image Transparency
A2	Sales Overview
B2	logo.png
C2	30%
A3	Profit Report
B3	background.jpg
C3	50%
A4	Customer Insights
B4	pattern.png
C4	20%

Formula Trace

Background Visible Opacity = 100% - Image Transparency %

Step 1: Image Transparency % for Sales Overview = 30%

Step 2: 100% - 30%

Step 3: Background Visible Opacity for Sales Overview = 70%

Cell Reference Map

    A           B               C
1 | Page      | Background Image | Image Transparency |
2 | Sales Ov | logo.png        | 30%               |
3 | Profit R | background.jpg  | 50%               |
4 | Customer | pattern.png     | 20%               |

The formula uses the Image Transparency values from column C for each report page.

Result

Page: Sales Overview
Background Image: logo.png
Image Transparency: 30%
Background Visible Opacity: 70%

The final result shows that the background image on the Sales Overview page will appear with 70% opacity, meaning it is mostly visible but slightly transparent.

Sheet Trace Quiz - 3 Questions

If the Image Transparency is 50%, what is the Background Transparency Effect?

A 100%

B 50%

C 0%

D 150%

Key Result

Background Visible Opacity = 100% - Image Transparency %