Background column of a row based on multiple columns

Q&A
,
1

Hi everyone,

I’m working on a Quick Sight table and I’d like to apply conditional formatting to highlight an entire row if either of two columns contains the value “Subtotal”.

So far, I’ve only been able to apply formatting based on one column at a time, but I need a rule that checks both columns simultaneously. Essentially, if column A = “Subtotal” OR column B = “Subtotal”, then the whole row should have a different background color.

Is there a way to achieve this in Quick Sight (either directly with conditional formatting rules or by creating a calculated field that can be used for formatting)?

Thanks in advance for your help!

2

Hi @elotorre,
So are you looking to highlight both ‘column a’ and ‘column b’ in your scenario, or just use ‘column a’ and ‘column b’ to highlight a third column?

I would suggest trying to setup a calculated field that may look like:

ifelse({Column A} = 'Subtotal' OR {Column B} = 'Subtotal', 'yes', 'no'

Then you can use that for your conditional formatting to set the background color of your column (or columns if needed).

I created a sample analysis in Arena for you to review and left the calculated field column in the visual to show for testing.
Background column of a row based on multiple columns

Let me know if you have any additional questions

3

It works. Thank you very much!

1 Like