Conditional Formatting - Columns

Q&A
, , , ,
1

Is it possible for a pivot table visual to have the columns coloured based on their values?
Not the traditional conditional formatting based on the count of the value column.

Essentially I have a RAG (Red, Amber, Green) visual, with a classification column before it which is just, 1, 2, 3, and 4. Then each of those will have the values of ‘Red’, ‘Amber’, or ‘Green’ in them. Is there anyway for all of ‘Red’ columns to have the background as Red, same for the Amber and Green columns.

This is how the visual looks:
image

I just want each colour named column to be the colour in which the value is, regardless of the value inside the cell.

Any questions or issues and please just ask, many thanks.

Riley

2

Hello @riley.anderson!

I did some testing and I was not able to do this via the conditional formatting options in the console. From what I understand you need a value to apply the color.

I will mark this as a feature request on conditional formatting for the Quick Sight team!