14. Visuals and Their Formatting
14.15 KPI Visual
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
Friends, don't make a mistake here: 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. Clear?
Ravindra Bagale's Tip – मराठी
मित्रांनो, इथे चूक करू नका: Avg Delivery Time किंवा Cancellation Rate साठी students Direction "High is good" वरच ठेवतात, त्यामुळे performance खराब झाला की KPI हिरवा दिसतो. या KPIs साठी Direction = Low is good set करा. Trend axis तुमचा Date table वापरतो याचीही खात्री करा. समजलं का?
Ravindra Bagale's Tip – हिंदी
दोस्तों, यहाँ गलती मत करना: Avg Delivery Time या Cancellation Rate के लिए students Direction को "High is good" पर छोड़ देते हैं, जिससे performance ख़राब होने पर KPI हरा दिखता है. इन KPIs के लिए Direction = Low is good set करो. यह भी पक्का करो कि trend axis तुम्हारी Date table इस्तेमाल करे. समझ आया?