This lesson's interactive features are locked, please to keep using them

Radial Gauges

Gauge visuals are great for showing progress toward a target. They're perfect when you want to track performance against a goal, like session quality, conversion rates, or average order value.

Gauges are one of my favorite visuals for executive dashboards. They instantly show "Are we hitting our target or not?"

Setting a Target Value

Gauges need a target to be meaningful. In recent versions of Power BI, you can't just type in a target number directly – you need to use a measure. This is actually a good thing because it keeps your targets consistent and maintainable.

Here's a simple workaround I use all the time:

sales_goal = 1005

That's it! A measure that just returns a constant value. Simple but effective.

Assignment

Create a new page and name it KPIs.
Create a measure on the website_sessions table called target_quality_score and set it to 50.
Create a new measure on the website_sessions table called max_quality_score and set it to 100.
Insert a Gauge visual in the top-left quarter of the page.
Drag session_quality_score_avg_scaled to the Value field.
Drag target_quality_score to the Target Value field.
Drag max_quality_score to the Maximum Value field.

Save the project and, from the course directory, submit the CLI tests.