Using Cards, KPI Visuals, and Gauge Charts in Microsoft Power BI

Course: Microsoft Power BI Training

Topic: Using Cards, KPI Visuals, and Gauge Charts

Course Link: Microsoft Power BI Training – JustAcademy

Demo Link: Register for a Free Course Demo

JustAcademy Website: Visit JustAcademy

1. Introduction to Cards, KPI Visuals, and Gauge Charts

Microsoft Power BI provides several visualizations for presenting important business metrics, monitoring performance, and comparing actual results with predefined targets. Cards, Key Performance Indicator (KPI) visuals, and gauge charts are especially useful for creating executive dashboards and performance-monitoring reports.

These visuals help report users understand important information quickly without examining large tables or complicated charts. For example, a sales dashboard may display total revenue in a card, monthly sales performance in a KPI visual, and progress toward a quarterly sales target in a gauge chart.

1.1 What Are These Visuals?

• Card visual: Displays a key value, such as total sales, total customers, profit, or average order value.
• KPI visual: Communicates performance against a goal and can show the direction or trend of performance over time.
• Gauge chart: Displays progress toward a target within a defined minimum and maximum range.

1.2 Learning Objectives

After completing this topic, learners should be able to:

• Understand the purpose and differences between cards, KPI visuals, and gauge charts.
• Create DAX measures for business performance calculations.
• Build single-value and multi-value card visuals.
• Configure KPI indicators, trend axes, and target values.
• Create gauge charts with minimum, maximum, and target values.
• Apply formatting, conditional colors, labels, and display units.
• Design a professional Power BI dashboard using these visuals.
• Troubleshoot common visual and data-modeling problems.

2. Understanding the Role of Summary Visuals

Business reports often contain thousands of records. Although detailed tables are useful for analysis, managers frequently need a quick overview of the most important measurements. Summary visuals convert detailed data into easily understood indicators.

2.1 Why Summary Visuals Are Important

• Quick decision-making: Important figures can be identified immediately.
• Performance monitoring: Actual results can be compared with targets.
• Better communication: Business results are easier to explain to stakeholders.
• Visual consistency: Similar metrics can be arranged in a consistent dashboard layout.
• Interactive analysis: Visuals can respond to slicers, filters, and selections from other report visuals.

2.2 Example Business Scenario

Imagine that a company wants to monitor its sales performance for the current financial year. Its dashboard may contain the following measurements:

3. Introduction to Card Visuals in Power BI

A card visual displays a numerical value prominently. It is commonly used to highlight important measurements at the top of a report page, allowing users to understand the overall business situation before examining detailed analysis.

3.1 Common Uses of Cards

• Total sales revenue.
• Total profit or loss.
• Total customers.
• Total products sold.
• Number of completed orders.
• Average delivery time.
• Customer satisfaction score.
• Conversion rate.

3.2 Types of Card Layouts

Power BI provides a modern card visual that can display one or multiple measures and supports additional details such as reference labels, images, and category-based layouts. Older reports may also contain legacy single-card or multi-row card visuals.

4. Creating a Card Visual

Follow these steps to create a card visual in Power BI Desktop.

1. Open Power BI Desktop and load a dataset.
2. Switch to Report view.
3. Select the Card visual from the Visualizations or Build visual pane.
4. Drag the required measure into the Values field well.
5. Resize and position the visual on the report canvas.
6. Open the Format visual pane to customize the appearance.
7. Set the title, callout value, font size, display units, alignment, background, and other formatting options as required.
8. Save the report.

4.1 Example: Display Total Revenue

Suppose the dataset contains an Orders table with a numeric Revenue column. Create a measure to calculate total revenue.

Total Revenue = SUM(Orders[Revenue])

Select the Card visual and add the Total Revenue measure to its Values field. The card displays the total revenue for the current filter context.

4.2 Example: Display Total Orders

If each row in the Orders table represents one order, you can count the rows.

Total Orders = COUNTROWS(Orders)

If the table contains multiple rows for each order, count the unique order identifiers instead.

Unique Orders = DISTINCTCOUNT(Orders[OrderID])

Choose the measure that matches the structure of the dataset. Incorrect counting logic can produce misleading dashboard results.

5. Creating Multiple Cards for a Dashboard

A dashboard often contains several cards arranged in a row above its charts and tables. This arrangement creates an overview of business performance.

5.1 Example Dashboard Measures

Total Revenue = SUM(Orders[Revenue])

Total Cost = SUM(Orders[Cost])

Total Profit = [Total Revenue] - [Total Cost]

Profit Margin =
DIVIDE([Total Profit], [Total Revenue], 0)

Unique Customers =
DISTINCTCOUNT(Orders[CustomerID])

Unique Orders =
DISTINCTCOUNT(Orders[OrderID])

Place each measure in a separate card or combine selected measures in a multi-value card visual. Format percentage measures as percentages and currency measures using the appropriate currency format.

5.2 Recommended Card Arrangement

6. Formatting and Customizing Cards

Formatting helps users distinguish important metrics and interpret their values correctly. A card should be easy to read without unnecessary decoration.

6.1 Callout Value

The callout value is the main number displayed in the card. Depending on the visual and available formatting options, you can adjust the font, size, color, display units, and decimal places.

6.2 Display Units

Large values may be displayed using abbreviated units such as K for thousands, M for millions, or B for billions. For example, 2,500,000 may appear as 2.5M when automatic display units are enabled.

To display the full value, select the card, open Format visual, locate the callout value settings, and set Display units to None when that option is available.

6.3 Titles and Labels

• Use meaningful titles such as Total Revenue instead of generic labels.
• Include currency symbols or percentage formats where appropriate.
• Use reference labels to show supporting context, such as variance from the previous month.
• Avoid excessive abbreviations that may confuse report users.

6.4 Backgrounds, Borders, and Spacing

Use consistent spacing and subtle backgrounds to separate cards. Align cards carefully and avoid excessive borders, shadows, or decorative effects that distract from the values.

6.5 Conditional Formatting

Where supported by the visual and formatting option, conditional formatting can change colors based on business rules. For example, a profit card may use one color when profit is positive and another when profit is negative. Color rules should be consistent and should not be the only way to communicate status.

7. Introduction to KPI Visuals

KPI stands for Key Performance Indicator. A KPI visual helps users evaluate a measure against a goal or expected result. It may also communicate the direction of performance over time.

For example, a company may have a monthly revenue target of ₹10,00,000. If the current revenue is ₹8,50,000, the KPI helps stakeholders recognize that the business has not yet reached its target.

7.1 Common KPI Examples

• Monthly revenue versus target.
• Profit versus budget.
• Actual production versus planned production.
• Customer satisfaction versus the required score.
• Completed projects versus planned projects.
• On-time deliveries versus the target rate.

7.2 Key Components of a KPI Visual

8. Creating a KPI Visual in Power BI

To create a KPI visual, prepare an indicator measure, a suitable trend field, and a target measure or value.

1. Load the dataset into Power BI.
2. Create or identify a measure representing the actual business result.
3. Ensure that a suitable date or sequence field is available for the trend axis.
4. Sort the trend field correctly before converting a standard visual into a KPI, if applicable.
5. Select the KPI visual from the Visualizations pane.
6. Add the indicator measure, trend-axis field, and target measure to their corresponding field wells.
7. Open Format visual to configure the indicator, trend display, labels, and colors.
8. Check that the result reflects the intended business definition.

8.1 Example: Revenue KPI

Assume that the business wants to compare total revenue with a monthly target of ₹10,00,000.

Total Revenue = SUM(Orders[Revenue])

Monthly Revenue Target = 1000000

Revenue Achievement % =
DIVIDE(
    [Total Revenue],
    [Monthly Revenue Target],
    0
)

The target measure above is a fixed example. In a real report, targets may be stored in a separate target table and related to dates, departments, products, or regions.

For a trend-based KPI, use an appropriate date field and ensure that the indicator measure returns meaningful values across the selected periods. A target measure should also be defined at the correct reporting grain.

8.2 Interpreting KPI Results

If actual revenue is ₹8,50,000 and the target is ₹10,00,000, the achievement percentage is 85%. The remaining amount required to reach the target is ₹1,50,000.

Revenue Remaining =
[Monthly Revenue Target] - [Total Revenue]

Use this result alongside the KPI when users need to understand the size of the gap, not just whether the target has been achieved.

9. Understanding KPI Targets and Trends

A KPI should be based on a clear business objective. A number alone does not explain whether performance is good or bad.

9.1 Higher Is Better

For metrics such as revenue, profit, and completed orders, a higher value may indicate better performance. The KPI's direction and formatting should reflect that business rule.

9.2 Lower Is Better

For metrics such as defect rate, customer complaints, and average processing time, a lower value may indicate better performance. Do not automatically interpret every increase as positive.

9.3 Trend Axis Considerations

• Use a meaningful time field, such as month or date.
• Sort months chronologically rather than alphabetically.
• Check that the indicator measure produces valid results across the selected periods.
• Use a proper Date table for reliable time-based analysis.
• Verify that blank values and missing periods do not distort the interpretation.

10. Introduction to Gauge Charts

A gauge chart displays a value within a defined range, commonly using a semicircular arc. It is useful for communicating progress toward a target or the current status of a single measurement.

The standard Power BI radial gauge typically contains a value, a minimum, a maximum, and an optional target. The filled portion of the arc represents progress through the configured range, while the target marker indicates the goal.

10.1 Common Uses of Gauge Charts

• Sales achievement against a monthly target.
• Production progress against planned output.
• Budget utilization.
• Percentage of tasks completed.
• Customer service performance against a response-time target.
• Capacity utilization within a defined operating range.

10.2 Main Components of a Gauge

11. Creating a Gauge Chart in Power BI

Follow these steps to create a gauge chart.

1. Open Power BI Desktop and load the required data.
2. Create a measure for the value to be monitored.
3. Select the Gauge visual in the Visualizations or Build visual pane.
4. Drag the measure into the Value field.
5. Add a target measure or value to the Target value field, if required.
6. Add measures to the Minimum value and Maximum value fields if those limits are data-driven.
7. Alternatively, configure the minimum, maximum, and target through the formatting options when supported and appropriate.
8. Format the title, callout value, labels, colors, and gauge axis.
9. Check that the current value and target use the same unit and reporting period.

11.1 Example: Sales Gauge

Assume that a business has generated ₹8,50,000 in sales against a target of ₹10,00,000, with a gauge maximum of ₹12,00,000.

Total Sales = SUM(Orders[Revenue])

Sales Target = 1000000

Gauge Minimum = 0

Gauge Maximum = 1200000

Place Total Sales in Value, Sales Target in Target value, and the appropriate minimum and maximum values in their field wells or format settings.

The gauge displays progress through the range from zero to ₹12,00,000 and marks the target of ₹10,00,000. Because the target is not the same as the maximum, the visual can show both the current progress and the goal.

11.2 Calculating Target Achievement

To calculate the percentage of the target achieved, create a measure:

Sales Target Achievement % =
DIVIDE(
    [Total Sales],
    [Sales Target],
    0
)

With sales of ₹8,50,000 and a target of ₹10,00,000, the result is 85%. Format the measure as a percentage if you display it in a card or other visual.

12. Understanding DAX Measures for Summary Visuals

DAX, or Data Analysis Expressions, is the formula language used in Power BI for creating measures and calculated columns. Measures are especially useful for cards, KPIs, and gauges because they recalculate based on the current filter context.

12.1 SUM Function

The SUM function adds values from a numeric column.

Total Revenue = SUM(Orders[Revenue])

12.2 COUNTROWS Function

The COUNTROWS function counts the rows in a table after applicable filters have been applied.

Order Rows = COUNTROWS(Orders)

12.3 DISTINCTCOUNT Function

DISTINCTCOUNT counts unique values in a column.

Total Customers =
DISTINCTCOUNT(Orders[CustomerID])

12.4 DIVIDE Function

DIVIDE calculates a ratio and allows you to specify a result when the denominator is zero or blank.

Profit Margin =
DIVIDE(
    [Total Profit],
    [Total Revenue],
    0
)

12.5 IF Function for Status Measures

The IF function can create a simple text status based on a business rule.

Revenue Status =
IF(
    [Total Revenue] >= [Monthly Revenue Target],
    "Target Achieved",
    "Below Target"
)

This status measure can be useful in tables or cards that support text values. It does not automatically configure every visual's conditional formatting; formatting rules must be set separately when required.

13. Understanding Filter Context and Interactivity

Power BI measures respond to filters and selections. For example, if a report user selects the West region in a slicer, the Total Revenue card may update to display revenue for that region.

13.1 Common Filters

• Date and financial year.
• Product category.
• Sales region.
• Sales representative.
• Customer segment.
• Order status.

13.2 Example

Suppose a card displays total revenue of ₹50,00,000 for all regions. When a user selects the North region, the card may update to ₹12,00,000, depending on the data model and filter relationships.

KPI and gauge visuals can also respond to slicers when their measures and relationships are configured correctly. Test each visual to ensure that its result changes as expected.

13.3 Edit Interactions

Use Power BI's visual interaction controls to determine whether selections in one visual should filter, highlight, or have no effect on another visual. This is useful when building dashboards where some metrics should remain fixed while others respond to selections.

14. Comparing Cards, KPI Visuals, and Gauge Charts

15. Best Practices for Designing Summary Visuals

15.1 Use Clear Business Definitions

Define each measure carefully. For example, distinguish between total order rows, unique orders, gross revenue, and net revenue. A visually attractive report is not useful if its metrics are incorrectly defined.

15.2 Select the Right Visual

• Use a card when the most important information is a single value.
• Use a KPI visual when users need to evaluate a result against a target and understand its trend.
• Use a gauge when a single value must be interpreted within a clear minimum-to-maximum range.

15.3 Avoid Too Many Gauges

Gauge charts occupy substantial space and typically focus on one measure. If a dashboard contains many metrics, cards or a well-designed KPI layout may be more space-efficient.

15.4 Choose Meaningful Targets and Ranges

Gauge minimum and maximum values should have business meaning. An unsuitable maximum can make progress look misleadingly high or low. Targets should reflect the relevant period, department, product, or region.

15.5 Use Consistent Formatting

• Use consistent number and currency formats.
• Keep titles short and descriptive.
• Use a consistent color scheme across related metrics.
• Show enough decimal places for accuracy without cluttering the report.
• Ensure that labels remain readable at normal report and mobile sizes.

15.6 Consider Accessibility

Do not rely on color alone to communicate success or failure. Add labels or meaningful text, maintain sufficient contrast, and verify that values are easy to read for users with different visual needs.

16. Common Problems and Troubleshooting

17. Practical Project: Sales Performance Dashboard

In this project, you will create a Power BI dashboard using cards, KPI visuals, and a gauge chart to monitor business performance.

17.1 Project Objective

Build an interactive dashboard that allows managers to monitor revenue, profit, orders, and progress toward a sales target.

17.2 Sample Dataset Structure

The sample values are illustrative. Your actual dataset may have different columns or a different structure.

17.3 Step 1: Load and Prepare Data

1. Open Power BI Desktop.
2. Choose Get data and select the appropriate data source.
3. Load the sales dataset.
4. Open Power Query to inspect column names and data types.
5. Ensure dates are stored as dates and revenue and cost are numeric.
6. Remove or correct invalid records where appropriate.
7. Apply the transformations and load the data into the model.

17.4 Step 2: Create Measures

Total Revenue = SUM(Orders[Revenue])

Total Cost = SUM(Orders[Cost])

Total Profit =
[Total Revenue] - [Total Cost]

Profit Margin =
DIVIDE([Total Profit], [Total Revenue], 0)

Total Orders =
DISTINCTCOUNT(Orders[OrderID])

Total Customers =
DISTINCTCOUNT(Orders[CustomerID])

Sales Target = 1000000

Target Achievement % =
DIVIDE([Total Revenue], [Sales Target], 0)

Revenue Gap =
[Sales Target] - [Total Revenue]

For a production report, replace the fixed target with a target measure that retrieves the appropriate goal from the data model. Make sure the target responds correctly to date and regional filters.

17.5 Step 3: Create Summary Cards

1. Add a Card visual to the report canvas.
2. Add the Total Revenue measure.
3. Set the display format to currency.
4. Repeat the process for Total Profit, Profit Margin, Total Orders, and Total Customers.
5. Align the cards across the top of the report.
6. Use consistent titles, fonts, spacing, and display formats.

17.6 Step 4: Create a Revenue KPI

1. Add a KPI visual.
2. Set the indicator to Total Revenue.
3. Assign a valid date or period field to the trend axis.
4. Assign the appropriate target measure or value.
5. Configure the trend direction and formatting according to the business definition.
6. Test the KPI using the date slicer and other relevant filters.

17.7 Step 5: Create a Sales Gauge

1. Add a Gauge visual.
2. Assign Total Revenue to Value.
3. Assign Sales Target to Target value.
4. Set the minimum to zero if that is appropriate for the metric.
5. Set a meaningful maximum, such as a planned upper range for monthly sales.
6. Format the gauge labels and title.
7. Confirm that the gauge reflects the selected period and region correctly.

17.8 Step 6: Add Slicers

Add slicers for OrderDate, Region, and Product Category if those fields are available. Confirm that the cards, KPI, and gauge respond to slicer selections as intended.

17.9 Step 7: Validate the Dashboard

• Compare the Total Revenue card with a trusted total from the source data.
• Verify that profit equals revenue minus cost.
• Check the target and achievement calculations.
• Test multiple dates and regions.
• Confirm that the gauge minimum, maximum, and target are sensible.
• Ensure that titles, labels, and number formats are consistent.

18. Exercises and Practice Questions

Exercise 1: Basic Card

Create a card that displays total revenue from a sales dataset. Format the value as currency and give the card a meaningful title.

Exercise 2: Multi-Measure Summary

Create cards for total profit, total orders, total customers, and profit margin. Arrange them into a single dashboard row.

Exercise 3: KPI Target Monitoring

Create a KPI visual that compares monthly revenue with a target. Include a valid date-based trend axis and configure the trend direction.

Exercise 4: Gauge Chart

Create a gauge chart that displays the current sales value against a target. Choose a meaningful minimum and maximum and explain why those values are appropriate.

Exercise 5: Interactive Dashboard

Add a region slicer and verify that the cards, KPI, and gauge respond correctly. Compare results for two different regions.

Exercise 6: Troubleshooting

A card displays an unexpectedly high total, the KPI trend is out of order, and the gauge appears almost full. Identify a possible cause for each issue and explain how you would correct it.

19. Interview Questions and Answers

Q1. What is a card visual in Power BI?

Answer: A card visual highlights one or more important values, such as revenue, profit, customer count, or order volume.

Q2. What is a KPI visual?

Answer: A KPI visual helps measure performance against a target and can communicate the direction of performance over a trend axis.

Q3. What is a gauge chart?

Answer: A gauge chart displays a value within a defined range and can show a target marker to communicate progress toward a goal.

Q4. What is the main difference between a card and a KPI visual?

Answer: A card primarily highlights a value, while a KPI visual is intended to evaluate a measure against a goal and can include trend information.

Q5. When should you use a gauge chart?

Answer: Use a gauge when the status of a single measure within a meaningful range is important, such as sales progress toward a target.

Q6. What is a target value in a gauge chart?

Answer: The target value represents the desired result and is shown as a marker on the gauge.

Q7. What is the purpose of a trend axis in a KPI visual?

Answer: The trend axis provides a sequence, commonly dates or periods, through which the indicator's performance can be evaluated.

Q8. Why should DAX measures be used for summary visuals?

Answer: Measures provide reusable calculations that respond to the current filter context and can be used across cards, KPI visuals, gauges, and other report elements.

Q9. Why might a card display an abbreviated number?

Answer: Its display units may be set to Auto, which abbreviates large values using K, M, or B. Change the display units to None when the full number is needed.

Q10. Why is a KPI trend sometimes displayed incorrectly?

Answer: The trend field may be sorted incorrectly, the measure may return blank values, or the trend axis may not represent the intended sequence.

Q11. Can cards and gauges respond to slicers?

Answer: Yes. They can respond to slicers when the data model, relationships, measures, and visual interactions are configured correctly.

Q12. What happens if the gauge maximum is too small?

Answer: The gauge may appear almost full, even if the value is not close to the business target. Set a meaningful maximum for the metric.

Q13. What is the difference between target achievement and the remaining target?

Answer: Target achievement is commonly calculated as actual divided by target. Remaining target is target minus actual. These calculations answer different business questions.

Q14. Why is DIVIDE useful in DAX?

Answer: DIVIDE calculates a ratio and supports an alternate result for division by zero or a blank denominator, helping avoid unintended errors.

Q15. Can a dashboard use cards, KPIs, and gauges together?

Answer: Yes. Cards can summarize important values, KPIs can show progress and trends, and gauges can highlight progress toward selected targets. Use each visual where it provides clear value.

20. Quick Revision Checklist

• Understand the purpose of card visuals.
• Know how to create single-value and multi-value cards.
• Use suitable DAX measures for revenue, profit, orders, and percentages.
• Format currency, percentages, decimals, and display units correctly.
• Understand KPI indicators, targets, and trend axes.
• Ensure date fields are sorted correctly for time-based KPIs.
• Understand gauge values, minimums, maximums, and targets.
• Use business-appropriate ranges for gauge charts.
• Test interactions with slicers and filters.
• Validate results against the source data.
• Apply consistent formatting and accessible design practices.
• Choose the visual that best answers the business question.

21. Conclusion

Cards, KPI visuals, and gauge charts are valuable tools for building clear and effective Power BI dashboards. Cards highlight important business figures, KPI visuals help users evaluate performance against targets and trends, and gauge charts communicate progress within a defined range.

To use these visuals effectively, create accurate DAX measures, define meaningful targets, choose appropriate ranges, format values consistently, and test how the report responds to filters. Combining these techniques helps transform raw business data into useful information for decision-making.

Explore the training course: Microsoft Power BI Training at JustAcademy

Register for a course demo: Register Here

Official Microsoft learning resources:

• Create a Card Visual in Power BI
• Create Key Performance Indicator (KPI) Visualizations
• Radial Gauge Charts in Power BI
• Overview of Visualizations in Power BI