0
0
Power BIbi_tool~10 mins

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

Choose your learning style9 modes available
Sample Data

Sales data by city with geographic coordinates for map visualization.

CellValue
A1City
B1Sales
C1Latitude
D1Longitude
A2New York
B21000
C240.7128
D2-74.0060
A3Los Angeles
B3850
C334.0522
D3-118.2437
A4Chicago
B4600
C441.8781
D4-87.6298
A5Houston
B5400
C529.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
Test your understanding
What is the total sales value calculated from the data?
A2850
B2950
C2500
D3000
Key Result
SUM aggregates numeric values from a column to produce a total.