Gauge visual is represented by circular arc like visual which shows progress of a certain value towards the target. Needle line represents the target value. The value showing in the middle of the gauge is the gained Value. Left and right side of the gauge represents Minimum and maximum value.
In this visual we are Tracking medals won with their target.
How to Proceed?
Step 1
Launch power BI desktop app and open the new report page and import the data required.
Refer Lesson 7 - Power BI Datasets to build visuals
Step 2
In “visualizations” pane click on “Gauge” which is highlighted in the given figure.
Step 3
Drag the data fields into “Field Section” that you want to analyze.
Values: Display the Progressed Value – Count of Medal
Minimum Value: Minimum medals won
Maximum Value: Maximum medals won
Target value: Add a goal – Average of Target
By default, in gauge, minimum value is set to 0 and maximum value is set to double the current value. Current value is set as halfway point on the gauge
We can set the minimum, maximum and target value based on the current value.
Here we are setting Minimum and maximum value based on the medals won, target is derived from the Medal Target table where we have predefined Target value.
In the above visual, we have slicers applied. For Canada region in the Year 1992, medal won was 80. Gauge Needle shows region met the Average target.
Manual options to set value
We can set maximum, minimum and target value manually in format visual options.
Step 4 Customizing the appearance
You can customize the color of the target and current value fill color. Conditional formatting of the fill color in the gauge can be customized by clicking fx icon
Data labels font, color, style of the values can be customized under formatting section.
Step 6 Save the visual
Finally, Gauge visual is ready. Click save button to save the visual.
When to use Gauge visual?
Gauge visual can be used when we want to show progress of the metric value towards the target or when we want to display information in an easy quick way to understand.
Pros
- Users can easily interpret and understand the data better.
- Interactive.
- Threshold visualization
Cons
- Not suitable for all types of metrics
- Only limited information can be given in chart
- Only single metric can be analyzed.
Conclusion
Gauge charts in Power BI are effective for highlighting single metrics, especially when you want to convey success or failure against predefined targets.
| Tags | Power BI |
| Useful links | |
| MS Learn Modules | |
| Test Your Knowledge | Quiz |
No comments:
Post a Comment