Forum Discussion
Conditional Formatting Not Working for New Records
Anonymous a few years late but...did you ever find a solution to this issue? I'm facing the exact same problem:
- Conditional formatting is based on an ID field. Such an ID exists for every row in the dataset.
- All IDs appear in the table visual until I start adding measures.
- Once I add measures, only rows with a value for at least one measure remain.
- When I click on 'Shows items with no data' in the table, all IDs are back to appearing. However, certain IDs are not formatted despite meeting the criteria...which once again is based on the ID field and not measures.
- When I add 'Measure = 1' to the table, all of the IDs appear and are conditionally formatted.
- Similarly, if I do not add 'Measure = 1' to the table, but rather switch the ID to 'First' instead of 'Don't Summarize', all IDs appear and are conditionally formatted.
I would like to understand why this is happening