Hi, I am working on my dashboard and encountered some problems. I have metric name in my rows, metric value and difference as values, most of my metrics are in percentage but there are 2 metrics that I don’t want them to be percentage: nIXD_Spread and rIXD_Spread. But if I click on the 3 dots and change the format of metric value and difference, then all of the metrics will change to that format. I am wondering if there is a way to customize so nIXD Spread and rIXD spread can just be normal decimals and other metrics can be percentages.
Hi @Bonnie213,
Unfortunately, this type of scenario is a current limitation within QuickSight; When adjusting the format of a field, it will affect all values within that field, therefore you are unable to assign a specific format to specific values within a field (like your scenario). The best work around for this scenario would be to duplicate your metric value field (create a calculated field for it), that way you can apply your percentage format to one of the value fields (that handles nIXD_Spread and rIXD_Spread) and then you can assign a different format to your second value field. The issue with this though is that it will create duplicate columns for each section. There’s currently no way to create a scenario where values show different formats within the same column.
Let me know if you have any additional questions!
Ok I see! One more question I have is about the difference column I have. I used conditional formatting to change the colors but you see how it only changes the color of the group under each metric, and on the metric name it’s all black, I want all the values in that column to change color. Is there a way to do that?
Hi @Bonnie213,
You can change the color of your subtotal rows but unfortunately not through conditional formatting. As the conditional formatting options only allow you to set based off a ‘column’ field, it’s assigning the formatting to the actual data within the field(s), but does not have control over the table calculation options, like subtotal numbers.
Additional formatting controls would be helpful when working with tables in QS so I’ll mark this as a feature request to promote visibility to the support team.
Let me know if you have any additional questions.