KPI Visual Conditional Formatting Resets

Q&A
1

I’m using the KPI Visual with a calculated field as my target value in an Analysis.

Whenever I set the conditional formatting on the visual, it resets to the default options any time I change the calculated field value.

Is this a known bug?

2

Hi @mjproperty ,

Welcome to the Quick Sight Community!

Can you help with some more information on the conditional formatting config and the field used?

Or if you can create a sample in the Arena to show the issue, can try to check the reason.

Thanks,
Prantika

3

@prantika_sinha I’m not sure if I’ve used the Arena correctly, but here is the embed link: KPI_Testing

Exact steps to reproduce issue:

  1. Add KPI Visual
  2. Add field to be used as KPI Value
  3. Create calculated field to be used as target.
  4. Add calculated field as KPI target
  5. Open Format visual properties
  6. Adjust conditional formatting (e.g. change Text Color default to include a third option)
  7. Select Apply to confirm changes to conditional formatting.
  8. Reopen Format visual properties and confirm your changes to conditional formatting were saved.
  9. Edit the calculated field that is used as target and change the value.
  10. Reopen Format visual properties and your changes to the conditional formatting are reset to the defaults.
4

I could see the behavior, the default conditional formatting is getting cleared off when we are editing the field value.

I am not sure of the use case, but to replicate the same, I used an integer parameter and added a parameter control for the same to change the value within the calculated field. And the conditional formatting worked.

I am not sure of the reason for the behavior and can think of raising this case with the team. However check if the alternate approach help you resolve this.

Thanks.

5

@prantika_sinha Thank you! That work around you offered worked.

Please do raise the issue with the team though, there is no use case in which the current behavior is appropriate.

6

You can open up a support ticket with AWS team, sighting your case and the default behavior.