Facing an odd conditional formatting (CF) issue that we cannot resolve.
Sorry, no file sharing due to sensitive data. Working with Feb 2021 version of the desktop.
We have an older file initially created ~2.5 years ago. It contains a table showing the results of various DB tests. The DB writes to a Pass/Fail (P/F) column with a '1' for pass, '0' for fail. This P/F column is used in the CF rule. Pretty basic stuff. If a 1, then background = green, if 0 then background = red.
It works fine for all rows of the table EXCEPT 6 new tests we added. Remove/re-add the rule and recreating the entire table gives the same result. No CF on those new rows. We have verified that the column is set to Integer.
If the P/F column is added to the table itself, it shows the values as expected AND it applies the correct formatting!
If I create an entirely new file, make the direct query connection to the data, and recreate the table, it works just fine.
I have also compared the report settings in the options and matched the old file to the new. No change.
There are no visual nor page level filters applied.
I searched the update blogs but did not find any references to this specific issue.
However, we do not wish to add that extra column, even if we made it essentially invisible as @Greg_Deckler suggested. It also does not make sense as to why only the new rows would be affected and would need the additional column to work correctly.
Still looking for assistance here if anyone could provide insight.