In Quick Sight report, formating question

Q&A
1

I need to format format currency and % data in same column based on the row value
for example I want to format last item as % and rest of the are $

image
image764×203 22.1 KB

2

Hi @RAHUL_singh1

Use ifElse to convert values to string and append formatting manually. This treats the column as a string, so it cannot be used in numeric aggregations anymore.

Example: (Note: Replace the fields and values from your dataset)

ifelse(
  [Metric Type] = 'Percentage', 
  concat(toString(round([Value] * 100, 1)), '%'),
  concat('$', toString(round([Value], 1)))
)
1 Like
3

HI @Xclipse I am using Pivot view, so if i convert it into string, aggregation would be change from sum to count. So i cannot see the actual value instead count.

image
image546×735 34.4 KB

4

Hi @RAHUL_singh1

You’re absolutely right in Pivot Table view, converting a numeric field to a string disables numeric aggregations (like sum or avg) and defaults to count, which breaks metric calculations.

If you want custom formatting (e.g., $ or %) based on row values, you must convert the values to string, but this prevents aggregation.

Quick Sight does not support dynamic number formatting per row within the same column. Number formats apply at the column level only not per row.