Applied steps and undo in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sample sales data by region before any applied steps.

Cell	Value
A1	Sales
A2	100
A3	200
A4	300
B1	Region
B2	North
B3	South
B4	East

Formula Trace

Applied Steps: Filter Region = 'North' -> Add Column: Sales Tax = Sales * 0.1 -> Undo last step

Step 1: Filter rows where Region = 'North'

Step 2: Add column 'Sales Tax' = Sales * 0.1

Step 3: Undo last step (remove 'Sales Tax' column)

Cell Reference Map

   A       B       C
1| Sales | Region | Sales Tax
2|  100  | North  |  10
3|  200  | South  |     
4|  300  | East   |     

Columns A and B are original data. Column C is added in step 2 and removed in step 3.

Result

   A       B
1| Sales | Region
2|  100  | North

Final table after undo shows only filtered rows with original columns, no Sales Tax column.

Sheet Trace Quiz - 3 Questions

What does the first applied step do?

A Removes the Sales Tax column

B Adds a new column for Sales Tax

C Filters rows to only show Region 'North'

D Sorts data by Sales

Key Result

Applied steps modify data step-by-step; undo reverses the last applied step.