A Practical Guide to Card and Gauge Visuals in Power BI 

Definition 

• Card: A Card is a simple, single-value visual that displays a single, important number from your dataset (e.g., Total Sales, YTD Revenue, Customer Count). It is the most fundamental Key Performance Indicator (KPI) visual. 

• Gauge: A Gauge (or Speedometer Chart) is a semi-circular visual that measures a value against a defined target and performance bands (e.g., Good, Average, Poor). It shows progress toward a goal. 

Key Purpose 

• Card: To prominently display a single, critical metric that requires immediate attention and is central to a report’s narrative. Its purpose is to answer a specific question at a glance. 

• Gauge: To visualize the performance of a key metric against a predefined target or goal. It instantly communicates whether performance is on track, underperforming, or exceeding expectations. 

How the Card and Gauge Visual Works in Power BI 

Card 

• It performs an aggregation (e.g., Sum, Average, Count) on a single numerical field. 

• It displays the result as a large, clear number on the report canvas. 

Gauge  

• The needle represents the current value of the metric. 

• The axis defines the minimum and maximum possible values. 

• The colored performance bands (e.g., red, yellow, green) represent target ranges. 

• The target line shows the specific goal to be achieved. 

When to Use Card and Gauge Visuals in Power BI 

Card 

• Displaying a high-level KPI on a summary page or dashboard. 

• When the exact value is more important than its visual trend over time. 

• As a focused headline figure for a more detailed report section. 

Gauge 

• Tracking progress toward a sales quota, budget goal, or efficiency target. 

• When performance can be clearly categorized into ranges (e.g., 0-60% = Bad, 60-90% = Okay, 90-110% = Good). 

• Providing a quick, intuitive health check for a specific metric. 

 Advantages of Card and Gauge Visuals 

Card 

• Clarity and Focus: Draws immediate attention to the most important number. 

• Space-Efficient: Fits into small areas of a crowded dashboard. 

• Highly Readable: The large font size is easy to read from a distance. 

Gauge 

• Intuitive Understanding: The speedometer metaphor is widely recognized. 

• Instant Performance Context: The needle’s position relative to the colored bands provides immediate qualitative feedback. 

• Motivational: Effectively shows how close a team is to hitting a target. 

These strengths make Cards and Gauges essential for building executive dashboards and performance-tracking reports. 

Limitations of Card and Gauge Visuals 

Card 

• Provides no context on its own (e.g., trend over time, comparison to prior period). 

• Can be misleading if not accompanied by supporting visuals or proper date filters. 

Gauge 

• Inefficient Use of Space: They occupy a large canvas area to display essentially one data point. 

• Imprecise Reading: It can be difficult to discern the exact value from the needle’s position; a Card is often better for precision. 

• Simplistic: Cannot represent complex relationships or multi-dimensional data. 

• Gauges are poor for comparisons. They display one target well, however if a user needs to compare performance across multiple products or regions, a simple Bar or Column chart is superior. 

Demo 

This guide uses the ‘Black Friday Sales’ dataset available on Kaggle.com. Upload the train.csv file into Power BI to follow along. 

The columns used for this demo are: 

• User_ID: Identifier for the buyer. 

• Purchase: The purchase amount of the transaction. 

Loading Data in Power BI Desktop: 

1. Open Power BI Desktop. 

2. Click Get Data > Text/CSV. 

3. Navigate to and select the train.csv file. Click Load. 

Case I: Creating a Card for Total Sales 

In this example, we will create a Card to display the grand total of all sales. 

• In the Visualizations pane, click the Card icon (a single number). 

• An empty visual will appear on the canvas. 

• In the Fields pane, locate and drag the Purchase field into the Fields bucket of the visual. 

The Card will automatically update to show the Sum of Purchase, giving you a powerful headline figure for your dashboard as shown in figure 1. 

Case II: Creating a Gauge for a Sales Target 

 
Here, we will create a Gauge to measure if total sales meet a specific target (e.g., $4 Billion). 

Create a Target Table: We need a target value. Go to the Data view, click Enter Data, and create a simple table: 

Column Name: KPI 

Column Name: Target Value 

Row: Total Sales Target, 4,000,000,000 

Click Load. 

• Create the Gauge Visual: 

• In the Visualizations pane, click the Gauge icon. 

• Drag the Purchase field to the Value field. 

• Drag the Target Value field from your new Target table to the Target value field. 

Configure the Gauge (Optional): 

• In the Format your visual pane, expand the Gauge axis section. 

• Set the Min to 0 and the Max to 10,000,000,000 to define the scale. 

• Expand the Target section to change the color of the target line. 

• Expand the Callout value section to format the font size and color of the result. 

The resulting Gauge will show a needle for the total sales. The position of the needle relative to the target line and the colored bands instantly tells you if sales are below, meeting, or exceeding the $4B target.  

Ready to create powerful KPIs in Power BI?  

Put your skills to the test with our step-by-step guide using the ‘Black Friday Sales’ dataset. Download the data and start building your own insightful visuals today. Need a custom dashboard with advanced goals and metrics? Our technical team can help develop a solution tailored to your unique data story. Reach out for a consultation