Bug in Pivot Table with Conditional Formatting and Filter Action

Q&A
, , ,
1

I believe there is a bug in Pivot Tables when both a conditional formatting and a filter action are defined. After the filter has been used and disabled again (by clicking at the filtered row again), the cells for whom a conditional formatting is applicable stay “grayed out”. The issue can be reproduced as shown below.

  1. Create a PivotTable and specify a conditional formatting rule for the text color.
    In my example I set the text color to red if the sum of values is less than 100,000.
  2. Create a filter action
  3. Apply the filter by clicking a cell
  4. Click the cell again to disable the filter → the cells with the conditional formatting (which should have the red text color in my example) stay disabled and are thus hardly readable.

04_state_after_disabling_filter
04_state_after_disabling_filter282×461 16.7 KB

Can someone please confirm whether this is a general problem in QuickSight?

Would be great to fix it, because it’s very impractical to work with a PivotTable in this state.

2

Hi @matthias,

This has been reported by other community members as well. I recreated this in my environment and got the same issue. At the moment, the only substitute I was able to find is if you use a Table visual instead of a Pivot Table, but if this is not an option, I would highly recommend opening a support ticket: Case management - AWS Support.

Here are the other community posts where users raised the same behavior:

Hope this helps and feel free to keep us updated!

3

I’ve noticed that the bug appears to be resolved.

Thanks for your help.