Looker studio - pivot table conditional formatting

[kmy]

Hi!

Conditional formatting is not working in Pivot table in Looker studio. I have noticed it today, as several pivots, that used to be "colorful", are not so anymore. Is anyone else facing the same problem? Were there any new releases that changed it or smth?

Thank you!

[niveacreme34]

i have the exact problem. 3 days ago conditional formatting suddenly stopped working all across my pivots and standard tables. and no matter what i've tried, i couldn't get them back working.

[jcrowton]

Conditional formatting on my pivot tables are now broken as well. I tried to re-apply the formatting and it is still not working. 

[cgrinham]

I have the same issue - conditional formatting was working last week now it is not applying at all

[stefsonorus123]

Same issue here. Conditional formatting on Pivot table worked fine for about a year and suddenly stopped this week. Can not bring back

[kmy]

does anybody know, how to report this bug?

[harrikirik]

We have the same problem. Use to work fine before. Now, it is not working in all of our reports.

[angeltba]

Same problem, we have a few weeks with no Conditional Formatting being applied to Pivot Tables

[angeltba]

Any update on this?

[benzarb]

I faced this issue when applying a conditional format on a field created directly in the pivot table.

I created a new source field and then used this field in the pivot table and it worked.

[angeltba]

Thanks for the advice!

Definitely not the best solution, but at least it works that way for now

[EdgarA]

Hi everyone, 

Are you still seeing this issue? If so, is it just on previously created pivot tables or new pivot tables? Any specific conditional formatting scenarios where you are seeing this? Thank you!

[angeltba]

Hi,

I'm was seeing it in both previous and new pivot tables, but I just test it, and it works fine for new pivot tables now.

Previous Pivot tables are still not applying the styles, but removing and re-adding fields, or just re-selecting the field in previous pivot tables fix it!

[EdgarA]

Thanks for letting me know. I'm happy to hear it appears to be resolved now!

[nitish1995]

Yes, I'm also facing the same issue.

[harrikirik]

Seems existing tables are not fixed automatically. But depending on the table, there can be relatively easy ways to get it fixed. For example, I have conditional colouring based on a metric (average value of a field). The colouring starts working for me when I:

1) Add the same metric (the colouring is based on) to the table the second time. E.g. a duplicate - the exact same metric twice. This is a good way to go, as it retains all naming and metric settings. For the freshly added metric, the colouring starts working.

2) Remove the original metric, which still doesn't work. After this, I have a fully working colouring again.

Now, I have about 50 reports for different clients, so I have do this 50 times. Which is annoying. But at least it seems to fix it without any bigger work 🙂

[boris79]

Hi everyone! To resolve this issue, simply go to the edit conditional formatting rule and select the "Apply when collapsed" checkbox. I hope this helps!