Pivot Table Formatting - Color-code columns

Is it possible to colour-code contents of a particular column(identified by column header) in quicksight pivot tables?


For instance, I would like to color the contents of the columns with name Price in blue and with the name absolutes in red.


Yes you can conditionally format text to be certain colors.

You would then hardcode the values per column.

Essentially you’re going to have to pick a color for each column anyways so you can just hardcode it.


Hi Max,

Thanks for the solution, this does not work on my pivot table visualization. All the values are calculated fields - most of them using Level-Aware Calc. Is there any known limitation to conditional formatting in QS?


Many thanks!


Are you saying you can’t base your text color off of your calculated field?

Why do you need to base it off of your calculated field if you just want the color to be based off of the column name?

You could base it off of any row and have it always show that color.

1 Like

Hi Max,

All the value fields in my pivot table are calculated fields and I want to color code basis some words in the column headers.

Having said that, I cannot add a condition to color code basis header names and am trying to do it via the values of that field instead. And this does not work, if the value is a calculated field.

PS - I’ve tried conditional formatting before with other pivot tables with regular measure fields and works well with them.


So when you click apply the Gap Titles rows don’t go blue?

Also, you cannot conditionally format a header.

You can do a blanket formatting of all headers but not individual ones.

1 Like

Yes, when I hit apply - there is no change in the color. Any hacks to get around this?

Hmm it should work.

Can you show me your table? All of the values are greater than zero right?

The values are all >0. Looks like there is an issue with this pivot table - as I’m also seeing a lot of delay/ lag for all the fields of the pivot table to load.
Actually, this works in another pivot table even with calculated fields.

Does you other table have what you are looking for?

I’ve encountered some visuals that just don’t work so I need to delete them and create a new one sometimes.

Yeah, I think this was an issue with the pivot table. I cleaned it up entirely - and redid it and it works fine so far even with the formatting.

Thanks for looking into it, Max.

1 Like