Search results

How to add fixed target value in KPI card widget

We can add a fixed target value in the KPI card widget using the Expression and Max function.

Follow these steps to achieve this requirement.

  1. Create an expression column with the required default value and save the data source.

    Create Expression with default value

  2. Drag and drop the KPI card widget and bind the required value column in the Actual Value field, then bind the created expression column in the Target Value field and apply the Max function.

    Assign Expression in KPI card widget

  3. Now, you can apply the required formatting for values.

    KPI Card Preview