KPI visual in Power BI - Dashboard Guide

Dashboard Mode - KPI visual

Dashboard Goal

Show the total sales amount and compare it to the sales target to quickly see if sales are on track.

Sample Data

OrderID	Product	SalesAmount	SalesTarget
1001	Chair	150	200
1002	Table	300	200
1003	Lamp	100	200
1004	Sofa	450	200
1005	Desk	200	200

Dashboard Components

• KPI Card: Total Sales
  Shows the sum of all sales amounts.
  Formula: Total Sales = SUM(Sales[SalesAmount])
  Result: 150 + 300 + 100 + 450 + 200 = 1200
• KPI Card: Sales Target
  Shows the fixed sales target value.
  Formula: Sales Target = 200 * COUNTROWS(Sales)
  Result: 200 * 5 = 1000
• KPI Card: Sales vs Target
  Shows the difference between total sales and target.
  Formula: Sales vs Target = [Total Sales] - [Sales Target]
  Result: 1200 - 1000 = 200
• KPI Visual
  Displays Total Sales with an indicator comparing it to Sales Target.
  Green if sales >= target, red if below.

Dashboard Layout

+----------------+----------------+----------------+
| Total Sales    | Sales Target   | Sales vs Target|
|   [ 1200 ]     |    [ 1000 ]    |     [ 200 ]    |
+----------------+----------------+----------------+
|                KPI Visual (Total Sales vs Target)               |
|                      [Green Indicator]                         |
+----------------------------------------------------------------+
    

Interactivity

Adding a slicer for Product allows filtering the sales data. When a product is selected, all KPI cards and the KPI visual update to show sales and target only for that product.

Self Check

If you add a filter for Product = 'Table', which components update and what are their new values?

• Total Sales: 300
• Sales Target: 200
• Sales vs Target: 100 (300 - 200)
• KPI Visual: Shows 300 with green indicator (sales above target)

Key Result

A simple KPI dashboard showing total sales, sales target, and their comparison with a color indicator.