0
0
Power BIbi_tool~10 mins

Line charts in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Monthly sales data for the first five months of the year.

CellValue
A1Month
B1Sales
A2Jan
B2100
A3Feb
B3150
A4Mar
B4130
A5Apr
B5170
A6May
B6160
Formula Trace
SUM(Sales)
Step 1: SUM(100, 150, 130, 170, 160)
Cell Reference Map
    A       B
1 | Month | Sales |
2 |  Jan  | 100  |
3 |  Feb  | 150  |
4 |  Mar  | 130  |
5 |  Apr  | 170  |
6 |  May  | 160  |

Sales values in column B are used in the SUM formula.
The formula references the Sales column (B2:B6) to calculate total sales.
Result
    A       B       C
1 | Month | Sales | Total Sales |
2 |  Jan  | 100   |            |
3 |  Feb  | 150   |            |
4 |  Mar  | 130   |            |
5 |  Apr  | 170   |            |
6 |  May  | 160   |    710     |

A line chart would plot Months on the X-axis and Sales on the Y-axis showing sales trend over months.
The total sales value 710 is shown in cell C6. A line chart visualizes sales trends across months.
Sheet Trace Quiz - 3 Questions
Test your understanding
What is the total sales value calculated by the formula?
A710
B650
C600
D720
Key Result
SUM aggregates numeric values from a column to calculate total.