Gauge visual in Power BI - Dashboard Guide

Dashboard Mode - Gauge visual

Dashboard Goal

Show how close sales are to the target using a gauge visual.

Sample Data

Month	Sales	Target
January	120	200
February	150	200
March	180	200
April	210	200
May	190	200

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(SalesData[Sales])
  Result: 850
• KPI Card: Sales Target
  Formula: Sales Target = MAX(SalesData[Target])
  Result: 200
• Gauge Visual: Sales vs Target
  Value: Total Sales (850)
  Target: Sales Target (200)
  Minimum: 0
  Maximum: 1000 (set to 5 times target for scale)

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |     Sales Target     |
|       (KPI Card)      |      (KPI Card)      |
+----------------------+----------------------+
|                      Gauge Visual               |
|               Sales vs Target                    |
+-------------------------------------------------+

Interactivity

Adding a month filter updates the Total Sales KPI and the Gauge Visual to show sales progress for the selected month(s). The Sales Target remains constant as it is the fixed target value.

Self Check

If you add a filter for Month = March, what happens?

• Total Sales updates to 180.
• Gauge Visual updates to show 180 against the target 200.
• Sales Target stays at 200.

Key Result

Gauge visual showing total sales progress against a fixed sales target.