Scatter plots in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a scatter plot visual by selecting the correct field for the X-axis.

Power BI

ScatterPlot.XAxis = [1]

Drag options to blanks, or click blank then click option'

AOrderDate

BProductCategory

CCustomerName

DSalesAmount

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting a text field for the X-axis causes the scatter plot to not display correctly.

The X-axis in a scatter plot should be a numeric field like SalesAmount to show meaningful distribution.

2fill in blank

medium

Complete the code to set the Y-axis field for the scatter plot.

Power BI

ScatterPlot.YAxis = [1]

Drag options to blanks, or click blank then click option'

AProfit

BRegion

COrderID

DCustomerSegment

Attempts:

3 left

💡 Hint

Common Mistakes

Using categorical fields for the Y-axis results in an invalid scatter plot.

The Y-axis should be a numeric field like Profit to compare against the X-axis values.

3fill in blank

hard

Fix the error in the DAX measure that calculates the average sales for the scatter plot size.

Power BI

AverageSales = AVERAGE([1])

Drag options to blanks, or click blank then click option'

ACustomerName

BProductID

CSalesAmount

DOrderDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using a text or date column inside AVERAGE causes a calculation error.

The AVERAGE function requires a numeric column like SalesAmount to calculate the average correctly.

4fill in blank

hard

Fill both blanks to create a scatter plot with color representing category and size representing average sales.

Power BI

ScatterPlot.Color = [1]
ScatterPlot.Size = [2]

Drag options to blanks, or click blank then click option'

AProductCategory

BSalesAmount

CAverageSales

DCustomerRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Using numeric fields for color or categories for size confuses the scatter plot.

Color should be a category like ProductCategory, and size should be a measure like AverageSales to show differences clearly.

5fill in blank

hard

Fill all three blanks to write a DAX measure that calculates total profit for a selected region and product category.

Power BI

TotalProfit = CALCULATE(SUM([1]), FILTER(ALL('Sales'), 'Sales'[Region] = [2] && 'Sales'[ProductCategory] = [3]))

Drag options to blanks, or click blank then click option'

AProfit

B"West"

C"Electronics"

DSalesAmount

Attempts:

3 left

💡 Hint

Common Mistakes

Using SalesAmount instead of Profit changes the measure meaning.

Forgetting quotes around text filter values causes errors.

The measure sums Profit filtered by region "West" and category "Electronics".