Bar and column charts in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales data for different fruits showing product names and their sales numbers.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	150
A3	Bananas
B3	200
A4	Cherries
B4	120
A5	Dates
B5	180

Formula Trace

SUM(Sales)

Step 1: SUM(B2:B5)

Step 2: 650

Cell Reference Map

    A       B
1 Product  Sales
2 Apples   150  <--
3 Bananas  200  <--
4 Cherries 120  <--
5 Dates    180  <--

The formula references sales values in cells B2 through B5 to calculate total sales.

Result

Bar Chart:

Apples   |███████████ 150
Bananas  |████████████████ 200
Cherries |█████████ 120
Dates    |████████████ 180

A bar chart showing sales for each fruit. The length of each bar corresponds to the sales number, making it easy to compare values visually.

Sheet Trace Quiz - 3 Questions

What does the formula SUM(Sales) calculate in this data?

A The average sales per product

B The total sales of all products combined

C The highest sales value

D The number of products

Key Result

SUM(column) adds all numeric values in the specified column range.