KPI visualization % sign adjustment

Q&A
,
1

Hi team,

I would like to ask if there is an option to not display % sign in the KPI visual and only to have the number of difference between Value and Target Value ??

KPI
KPI642×222 20.4 KB

2

Hi @emil.zywina

Welcome to the Quick Suite community!

Yes, in KPI visuals you can switch the comparison display away from percent and show the absolute difference instead. The KPI comparison method supports the following options: Auto, Difference, Percent, and Percent difference. Choosing Difference will remove the % sign and display the numeric difference between the Value and Target Value.

image
image782×458 27.1 KB

3

Thanks for the answer. Maybe I need to clarify, what I want to achive is to have Actual Value = Overall GRI with % sign and the comparison difference without % sign.

So in this example Overall GRI = 88.3 % and number in the center will be 0.9 only

4

Hi @emil.zywina

Can you please try the following:

  1. Format Visual → Comparison section
  2. Set Comparison method to “Difference”
  3. Under Comparison format, change it from Same as value to one of the number formats (e.g., 1,234.57 or 1235 depending on your preference)

The Same as value option inherits the % sign from the primary value. By selecting a plain number format instead, the comparison will display as 0.9 without the % sign.

image
image295×433 15 KB

5

I’ve tried with this approach but unfortunately when I’m changing the calculate field to be show as: Percent, it immediately also changing the comparison format to be as Percent

KPI
KPI1437×613 68.3 KB

6

Hi @emil.zywina

Thank you for confirming. Yes, that’s the expected behavior, when the field is set to Show as: Percent it overrides the Comparison format as well.

The workaround is to not use Show as: Percent on the field, and instead format it as a plain number with a % suffix:

  1. Click the field in the Value well → change Show as back to Number (not Percent)
  2. Click Format → select More formatting options and Expand the Units section → in the Suffix field, type %
  3. Ensure the Comparison method is set to Difference
  4. Under Comparison format, select a plain number format (e.g., 1,234.57)

This way your primary value will still display as 88.36% (via the suffix), but the comparison value will show as 1.31 without the % sign, since its no longer treats the field as a true percentage type.

image
image283×587 15 KB

7

Thanks so much, after multiplying the formula by 100 that approach works as I expected :slight_smile: