BeyondERP.Newsletter
Menu

Setup step on the All KPIs page · Common

Set KPI goals and thresholds

Give each KPI a goal and thresholds that match the business target.

Used by
System user
Business process
Configure and manage reporting and analytics
Menu item
KPIDetailsGridMenuItem
Main table
AxKPITable
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA list of the key performance indicators (KPIs) defined in the system, which track performance against a goal and appear as tiles in workspaces or on the dashboard.
What you do hereUse this page to open a KPI, view its details and charts, and change its goal and thresholds or create new KPIs without development work.
ExampleFor example, BEAT's finance manager opens a revenue KPI, raises the goal from 1,000,000.00 to 1,200,000.00 and switches the thresholds to percentages (red below 80, green above 95). The KPI tile on the workspace turns from green to amber because the current value is now below the new goal.
All KPIs page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set KPI goals and thresholds

Give each KPI a goal and thresholds that match the business target.

Steps from Microsoft

  1. Go to Common > Common > All KPIs.
  2. Select the KPI you want from the list to open its details page.
  3. Select Edit.
  4. Enter the new goal value and change the threshold settings as needed.
  5. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
GoalThe target value the KPI is measured against.Microsoft Learn 1,200,000.00
Threshold typeWhether the red and green limits are values or percentages of the goal.Microsoft Learn Percentage

Common errors and fixes

MessageWhat to do
The tile colour doesn't change after editing the goalSave the KPI; saving re-evaluates it. Check the threshold type: percentage limits are applied to the goal, not to the value. Microsoft Learn

Test checklist

  1. Open a KPI from the list and note its value, goal and tile colour.
  2. Select Edit, change the goal, set Threshold type to Percentage with Red if less than and Green if more than values.
  3. Select Save and check that the status colour on the KPI tile changes to match the new goal.
  4. Set the goal and thresholds back and check the tile returns to its original colour.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set KPI goals and thresholdsSet the goal from the approved budget and use percentage thresholds so the colours still fit when the goal changesPercentage thresholds are calculated against the goal, so they follow a new goal without being edited again.Who maintains KPI goals?Changing a shared KPI for one user's view: the change applies to every user who sees the tile.Test: Goal change re-evaluates the tile

Feature management and licence

Licence or add-inOn the live system, these roles can open the page: System user, TestEssentialsRole.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyShared: a KPI's goal and thresholds apply to everyone who sees the KPI tile. Microsoft Learn
Can it be undoneReversible: Goals and thresholds can be edited again.
If you change it laterSaving a changed goal or threshold re-evaluates the KPI, so the status colour on its tile can change. Microsoft Learn
Technical architect

6Technical

Menu itemKPIDetailsGridMenuItem Checked in Dynamics 365
FormKPIDetails Checked in Dynamics 365
TableAxKPITableShown as “AXKPITABLE” in Record infoChecked in Dynamics 365
Who can open itPrivilegesOpen tile catalog KPIDetailsGridPrivilegeDuties KPIDetailsGridDuty
4 security roles AifTestSecRole EventTestRoleSystem user SystemUser TestEssentialsRole
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSystem user SystemUserTestEssentialsRole Give people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Save as, RestoreChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=KPIDetailsGridMenuItem
Data migrationLoad order: All KPIs has no data entity in Data management. Set goals and thresholds again on this page in each environment.Checked in Dynamics 365
Table definitionAxKPITable columns and relations Microsoft data model
Everyone

8Sources

To cite this step: CMN-KPI-010, Set KPI goals and thresholds. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CMN-KPI-010