Publishing paginated reports in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows a list of paginated reports with their current status and available actions before publishing.

Cell	Value
A1	Report Name
B1	Status
C1	Action
A2	Sales Summary
B2	Ready
C2	Publish
A3	Inventory Detail
B3	Ready
C3	Publish
A4	Customer List
B4	Draft
C4	Edit

Formula Trace

IF(B2="Ready", "Publish", "Edit")

Step 1: B2="Ready"

Step 2: IF(TRUE, "Publish", "Edit")

Cell Reference Map

    A           B         C
1 | Report Name | Status  | Action
2 | Sales Summary | Ready   | Publish ← formula uses B2
3 | Inventory Detail | Ready   | Publish
4 | Customer List | Draft   | Edit

The formula in column C checks the status in column B for each report to decide if the action should be 'Publish' or 'Edit'. Here, B2 is referenced to determine C2.

Result

    A           B         C
1 | Report Name | Status  | Action
2 | Sales Summary | Ready   | Publish
3 | Inventory Detail | Ready   | Publish
4 | Customer List | Draft   | Edit

The final result shows that reports with status 'Ready' have the action 'Publish', while those not ready show 'Edit'. This helps users know which reports can be published.

Sheet Trace Quiz - 3 Questions

What action does the formula assign if the status is 'Ready'?

A Delete

B Edit

C Publish

D Draft

Key Result

IF(StatusCell = "Ready", "Publish", "Edit") assigns action based on report readiness.