Map visualizations in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales data by city with geographic coordinates for map visualization.

Cell	Value
A1	City
B1	Sales
C1	Latitude
D1	Longitude
A2	New York
B2	1000
C2	40.7128
D2	-74.0060
A3	Los Angeles
B3	850
C3	34.0522
D3	-118.2437
A4	Chicago
B4	600
C4	41.8781
D4	-87.6298
A5	Houston
B5	400
C5	29.7604
D5	-95.3698

Formula Trace

SUM(Sales)

Step 1: SUM({1000, 850, 600, 400})

Cell Reference Map

    A         B         C          D
1 | City    | Sales   | Latitude | Longitude
2 | New York| 1000    | 40.7128  | -74.0060
3 | Los Angeles | 850     | 34.0522  | -118.2437
4 | Chicago | 600     | 41.8781  | -87.6298
5 | Houston | 400     | 29.7604  | -95.3698

References: Sales values in B2:B5, Latitude in C2:C5, Longitude in D2:D5

The formula uses the Sales column (B2:B5) to calculate total sales. Latitude and Longitude columns provide location data for the map.

Result

    A         B         C          D
1 | City    | Sales   | Latitude | Longitude
2 | New York| 1000    | 40.7128  | -74.0060
3 | Los Angeles | 850     | 34.0522  | -118.2437
4 | Chicago | 600     | 41.8781  | -87.6298
5 | Houston | 400     | 29.7604  | -95.3698

Total Sales: 2850

The total sales value 2850 is the sum of all sales. This data can be used to create a map visualization showing sales by city location.

Sheet Trace Quiz - 3 Questions

What is the total sales value calculated from the data?

A 2850

B 2950

C 2500

D 3000

Key Result

SUM aggregates numeric values from a column to produce a total.