Radial gauge charts in Power BI
Smart narrative visuals can be created and viewed in both Power BI Desktop and the Power BI service. The steps and illustrations in this article are from Power BI Desktop.
A radial gauge chart has a circular arc and shows a single value that measures progress toward a goal or a Key Performance Indicator (KPI). The line (or needle) represents the goal or target value. The shading represents the progress toward that goal. The The value inside the arc represents the progress value. Power BI spreads all possible values evenly along the arc, from the minimum (left-most value) to the maximum (right-most value).
In this example, you're a car retailer tracking the sales team's average sales per month. The needle represents a 140 cars sales goal. The minimum possible average sales is 0 and the maximum is 200. The blue shading shows that the team is averaging approximately 120 sales this month. Luckily, there's still another week to reach the goal.
Sharing your report with a Power BI colleague requires that you both have individual Power BI Pro licenses or that the report is saved in Premium capacity.
When to use a radial gauge
Radial gauges are a great choice to:
Show progress toward a goal.
Represent a percentile measure, like a KPI.
Show the health of a single measure.
Display information you can quickly scan and understand.
This tutorial uses the Financial sample Excel file.
From the upper left section of the menubar, select Get Data > Excel
Find your copy of the Financial sample Excel file
Open the Financial sample Excel file in report view .
Select financials and Sheet1
Select to add a new page.
Create a basic radial gauge
Step 1: Create a gauge to track Gross Sales
Start on a blank report page
From the Fields pane, select Gross Sales.
Change the aggregation to Average.
Select the gauge icon to convert the column chart to a gauge chart.
Depending on when you download the Financial Sample file, you may see numbers that don't match these numbers.
By default, Power BI creates a gauge chart where it assumes the current value (in this case, Average of Gross Sales) is at the halfway point on the gauge. Since the Average of Gross Sales value is $182.76K, the start value (Minimum) is set to 0 and the end value (Maximum) is set to double the current value.
Step 3: Set a target value
Drag COGS from the Fields pane to the Target value well.
Change the aggregation to Average.
Power BI adds a needle to represent our target value of $145.48K.
Notice that we've exceeded our target.
You can also manually enter a target value. See the Use manual format options to set Minimum, Maximum, and Target values section.
Step 4: Set a maximum value
In Step 2, Power BI used the Value field to automatically set minimum and maximum values. What if you want to set your own maximum value? Let's say that, instead of using double the current value as the maximum possible value, you want to set it to the highest Gross Sales number in your dataset.
Drag Gross Sales from the Fields pane to the Maximum value well.
Change the aggregation to Maximum.
The gauge is redrawn with a new end value, 1.21 million in gross sales.
Step 5: Save your report
Use manual format options to set Minimum, Maximum, and Target values
Remove Max of Gross Sales from the Maximum value well.
Select the paint roller icon to open the Format pane.
Expand Gauge axis and enter values for Min and Max.
Clear the COGS option in the Fields pane to remove the target value.
When the Target field appears under Gauge axis, enter a value.
Optionally, continue formatting your gauge chart.
Once you're done with these steps, you'll have a gauge chart that looks something like this:
More questions? Try the Power BI Community