Gauge visual in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the value field for the Gauge visual.

Power BI

Gauge.Value = [1]

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

AProductCategory

BCustomerName

COrderDate

DTotalSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using a text field like CustomerName instead of a numeric measure.

The Gauge visual's value field should be a numeric measure like TotalSales to show progress.

2fill in blank

medium

Complete the code to set the maximum value for the Gauge visual.

Power BI

Gauge.Maximum = [1]

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

ASUM(Sales[Amount])

B1000

CMIN(Sales[Amount])

DCustomerCount

Attempts:

3 left

💡 Hint

Common Mistakes

Using a measure like SUM(Sales[Amount]) which can change dynamically.

The maximum value for a Gauge is usually a fixed number like 1000 to represent the goal.

3fill in blank

hard

Fix the error in the DAX measure to calculate the current value for the Gauge visual.

Power BI

CurrentValue = CALCULATE(SUM(Sales[Amount]), [1])

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

AFILTER(Sales, Sales[Region] = "West")

BSales[Region] == "West"

CSUM(Sales[Amount])

DALL(Sales)

Attempts:

3 left

💡 Hint

Common Mistakes

Using boolean expressions directly inside CALCULATE instead of FILTER.

The CALCULATE function requires a filter expression like FILTER(Sales, Sales[Region] = "West") to filter the data correctly.

4fill in blank

hard

Fill both blanks to create a Gauge visual measure that shows sales progress as a percentage.

Power BI

SalesProgress = DIVIDE([1], [2]) * 100

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

ASUM(Sales[Amount])

BSUM(Sales[Target])

CCOUNT(Sales[OrderID])

DMAX(Sales[Amount])

Attempts:

3 left

💡 Hint

Common Mistakes

Using count or max instead of sum for amounts.

To calculate sales progress percentage, divide SUM(Sales[Amount]) by SUM(Sales[Target]) and multiply by 100.

5fill in blank

hard

Fill all three blanks to create a Gauge visual measure that shows sales progress with a dynamic maximum value.

Power BI

SalesProgressDynamic = DIVIDE([1], [2], 0) * 100
Gauge.Maximum = [3]

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

ASUM(Sales[Amount])

BSUM(Sales[Target])

CMAX(Sales[Target])

D100

Attempts:

3 left

💡 Hint

Common Mistakes

Using fixed maximum instead of dynamic maximum.

This measure divides actual sales by target sales with zero as fallback, multiplies by 100 for percentage, and sets the Gauge maximum dynamically to the maximum target value.