0
0
Power BIbi_tool~10 mins

Performance Analyzer in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data shows the performance timings of different visuals in a Power BI report as measured by Performance Analyzer. Each visual's rendering time is in milliseconds.

CellValue
A1Visual Name
B1Duration (ms)
A2Sales by Region
B2120
A3Profit Trend
B3250
A4Customer Count
B480
A5Total Duration
B5450
Formula Trace
=SUM(B2:B4)
Step 1: SUM(B2:B4)
Step 2: 120 + 250 + 80
Cell Reference Map
    A           B
1 | Visual Name | Duration (ms) |
2 | Sales by Region | 120        |
3 | Profit Trend    | 250        |
4 | Customer Count  | 80         |
5 | Total Duration  | [B2:B4]    |
The formula sums the values in cells B2, B3, and B4 which represent the duration of each visual's rendering time.
Result
    A           B
1 | Visual Name | Duration (ms) |
2 | Sales by Region | 120        |
3 | Profit Trend    | 250        |
4 | Customer Count  | 80         |
5 | Total Duration  | 450        |
The total duration of all visuals combined is 450 milliseconds, showing how long the report took to render all visuals.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula =SUM(B2:B4) calculate?
AThe average rendering time of visuals
BThe total rendering time of all visuals
CThe longest rendering time among visuals
DThe number of visuals in the report
Key Result
SUM(range) adds all numeric values in the specified cell range.