Ravindra BagaleCourses & study guides

14. Visuals and Their Formatting

14.15 KPI Visual

By Last updated:

Shows the current value, a target and the trend as a background area chart.

  • Field wells: Value, Trend axis (required, e.g. Month or Date), Target.
  • Example: Value = Total Orders; Trend axis = 'Date'[Year Month]; Target = Target Orders (from the Targets table). The indicator turns green when above target.
  • Formatting: Callout value, Icon, Trend axis (on/off, direction: High is good or Low is good, which matters for Avg Delivery Time!), Target label (distance to goal as % or absolute), Colours (good/neutral/bad).

Ravindra Bagale's Tip

Mitrano, ithe chuk karu naka: for Avg Delivery Time or Cancellation Rate, students leave Direction on "High is good", so the KPI shows green when performance gets worse. Set Direction = Low is good for these KPIs. Also make sure the trend axis uses your Date table. Samjla ka?