In this blog, we’ll learn How to Create Gauge chart in PowerBI. Firstly, we have to understand what is it and when should we use it.
Introduction to Gauge chart in PowerBI
Gauge: It uses a circular arc to present the value toward the target (maximum) point and a needle (line) represent the progress. To build it proper, it require Maximum, Minimum value and a Target value.
Dataset description
The dataset is a collection of sales data that can be analyzed with Power BI. It has different fields for sales success, customer demographics, and product information. This set of data can be used to look at sales patterns, figure out profits, figure out how customers act, and compare real sales to goals.
You can access the dataset here.
| Column Name | Description |
|---|---|
| Date | The date on which the sales transaction occurred. |
| Product | The name or identification of the product sold. |
| Quantity | The number of units of the product sold in the transaction. |
| Price | The unit price of the product at the time of the transaction. |
| Rate | The rate of the product after applying any discounts. |
| Discount | The discount applied to the product during the sale, either in percentage or monetary value. |
| Customer | The name or unique ID of the customer making the purchase. |
| Location | The geographical location (city, region, or country) where the transaction took place. |
| Total Sale | The total sales value for the transaction, calculated as Quantity * Rate. |
| Total Profit | The total profit generated from the transaction, calculated after deducting the cost of the goods sold from the total sales. |
| Target Sale | The sales target set for the transaction, which could be used to assess performance against goals |
Sample of Data:
Procedure to create Gauge chart in PowerBI:
Step1: Open your PowerBI Desktop on your Device
Step2: Click on Get Data button in Home Ribbon and select Text/CSV.
Step3: Open Prompt box will be open to select your text or csv file.
Step4: After selection of dataset, It will pop up a window for Load OR Transform Data. Click on Load to use data on PowerBI.
Step5: In the following picture, data has been loaded successfully.
Step6: Select Gauge from Visualizations Section (Right Hand Side).
Step7: Here, we’ll put the following data (from Sale) in different fields:
Value | Total Sale (Sum of Total Sale) |
Target value | Target Sale (Sum of Target Sale) |
After that you have to click on format your visual. Go to the General click on turn on visual border and the shadow. In the Visual border make the rounded corner of 15 px.
There are lots of things like ‘Small multiples’, ‘Tooltips’, Filters and Format, that can be apply on your visual.
In Visual Section,
- Data labels 🡪 Values 🡪 Color – #E6E6E6
- Target label 🡪 Values 🡪 Color – #E6E6E6
- Callout value 🡪 Values 🡪 Color – #E6E6E6
In General Section,
- Title 🡪 Title 🡪 Text color = #FFFFFF (White)
- Effect 🡪 Background 🡪 color = #000000 (Black)
- Effect 🡪 Visual border 🡪 color = #118DFF (Blue)
- Effect 🡪 Visual border 🡪 Rounded corners = 10 px
Insights from the Gauge chart in PowerBI
The gauge chart indicates that total sales of 25,375 are 90.5% of the target sales of 28,030, highlighting a shortfall and the need for strategies to close the gap.
Conclusion
Gauge chart in PowerBI can visualize progress toward a goal or target using a circular or semicircular dial. In a gauge chart, the dial shows the range of possible values, typically starting at zero and ending at a maximum value. A needle or arc indicates the current value within this range, often with color-coded areas to indicate different levels of performance. This helps to quickly assess how close the current value is to the target, making it ideal for tracking key performance indicators such as sales targets, completion rates, or capacity utilization.
If you like the article and would like to support me, make sure to:
- 👏 Like for this article and subscribe to our newsletter
- 📰 View more content on my DataSpoof website
- 🔔 Follow Me: LinkedIn| Youtube | Instagram | Twitter
