I want to apply conditional formatting based on the box_category field: if the value is “Large”, it should be red; if it’s “Small”, it should be blue. However, when I try to do this in Amazon QuickSight using the conditional formatting option and select box_category, it forces me to use an aggregation. I need the formatting to be based on the absolute (non-aggregated) value. Could someone please help me understand how to achieve this?
Hi @borahgb
Welcome to the QuickSight community!
You can apply conditional formatting on fields like box_category by setting the aggregation to ‘No aggregation’, and applying red for Large and blue for Small. Refer to the image for your reference.
