{"id":105,"date":"2026-02-26T08:02:43","date_gmt":"2026-02-26T08:02:43","guid":{"rendered":"https:\/\/gigz.pk\/powerbi\/?post_type=lesson&p=105"},"modified":"2026-03-17T07:06:26","modified_gmt":"2026-03-17T07:06:26","slug":"kpi-indicators","status":"publish","type":"lesson","link":"https:\/\/gigz.pk\/powerbi\/lesson\/kpi-indicators\/","title":{"rendered":"KPI Indicators"},"content":{"rendered":"\n

KPI (Key Performance Indicator) indicators are visuals that show whether a specific metric is meeting its target. They are used to track business performance, monitor goals, and provide quick insights<\/strong> at a glance.<\/p>\n\n\n\n

KPI indicators are ideal for metrics like revenue, profit, sales targets, or customer satisfaction.<\/p>\n\n\n\n

Components of a KPI<\/h2>\n\n\n\n
    \n
  1. Indicator Value<\/strong> \u2013 The actual value of the metric being measured (e.g., Total Sales).<\/li>\n\n\n\n
  2. Target Value<\/strong> \u2013 The goal or benchmark the metric is compared against.<\/li>\n\n\n\n
  3. Trend Axis<\/strong> \u2013 Optional. A time-based field (like Date) to show performance over time.<\/li>\n<\/ol>\n\n\n\n

    Creating a KPI in Power BI<\/h2>\n\n\n\n

    Step 1: Prepare Measures<\/h3>\n\n\n\n

    Create a measure for the value and target.<\/p>\n\n\n\n

    Example \u2013 Actual Sales<\/strong><\/p>\n\n\n\n

    Total Sales = SUM(Sales[Amount])<\/pre>\n\n\n\n
    Example \u2013 Sales Target<\/strong><\/p>\n\n\n\n
    Sales Target = 100000<\/pre>\n\n\n\n
    Step 2: Add KPI Visual<\/h3>\n\n\n\n
      \n
    1. Insert a KPI visual<\/strong> in your report.<\/li>\n\n\n\n
    2. Drag Total Sales<\/strong> into the Indicator<\/em> field.<\/li>\n\n\n\n
    3. Drag Sales Target<\/strong> into the Target Goal<\/em> field.<\/li>\n\n\n\n
    4. Drag Date<\/strong> (or another trend axis) into the Trend axis<\/em> field to show changes over time.<\/li>\n<\/ol>\n\n\n\n
      Step 3: Format KPI<\/h3>\n\n\n\n