Scatter plots in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales and Profit data for four products

Cell	Value
A1	Product
B1	Sales
C1	Profit
A2	Alpha
B2	1000
C2	200
A3	Beta
B3	1500
C3	300
A4	Gamma
B4	1200
C4	250
A5	Delta
B5	1800
C5	400

Formula Trace

Scatter plot with X axis = Sales, Y axis = Profit, Details = Product

Step 1: Select Sales values for X axis: {1000, 1500, 1200, 1800}

Step 2: Select Profit values for Y axis: {200, 300, 250, 400}

Step 3: Assign Product names as details for each point: {Alpha, Beta, Gamma, Delta}

Step 4: Plot points: (1000,200) Alpha, (1500,300) Beta, (1200,250) Gamma, (1800,400) Delta

Cell Reference Map

     A        B        C  
1 Product  Sales   Profit 
2 Alpha    1000    200   
3 Beta     1500    300   
4 Gamma    1200    250   
5 Delta    1800    400   

References: B2:B5 for X axis, C2:C5 for Y axis, A2:A5 for details

Sales values in column B and Profit values in column C are referenced for the scatter plot axes. Product names in column A label each point.

Result

Scatter Plot:

Y Axis (Profit)
|
|        * Delta (1800,400)
|           
|       * Beta (1500,300)
|          * Gamma (1200,250)
|    * Alpha (1000,200)
|____________________________
         X Axis (Sales)

The scatter plot shows four points representing products. The horizontal axis is Sales, the vertical axis is Profit. Each point is labeled by product name.

Sheet Trace Quiz - 3 Questions

Which column is used for the X axis in the scatter plot?

A Product

B Profit

C Sales

D None

Key Result

Scatter plots map one numeric column to X axis, another numeric column to Y axis, and use a categorical column for point labels.