Forum Discussion
Conditional Formatting display issue
Hi, I have a data source of 1s and 0s, the data type is whole number. When I apply conditional formatting, the 0s all change to the cross icon, however only a selection of the 1s change to the tick icon, the rest are just blank cells. 100% of the fields are populated, there are no blanks or errors. There is no reasonable explanation for this. In the image you can see me hovering a blank cell, and it has the value of 1 but no tick. All the blank cells have the value of 1 as well as the cells with a tick.
Hi amitchandak This is a whole number, I resolved the issue from switching from sum of the cell to average of the cell. Thank you
4 Replies
HarveyM Hello, could you please make sure you don't have any column in your table visual that makes your current column values blank.
for example even if in your main table, this column is not blank and it is fully filled, maybe if you put date from date table in this visual that in specific date you didn't have any 0 or 1, it makes the cell blank.
So please make sure about other tables in relationship with this table/column, that you have added to this visual.
I hope it helps.
Hi Anonymous There was no date relationships, or columns from other tables in the visual or filtering the visual. I solved the issue from switching the conditional formatting from sum of the cell to average of the cell. Thank you
HarveyM , Is you number is decimal number, Make sure it is a whole number. This is the first doubt I have.
Hi amitchandak This is a whole number, I resolved the issue from switching from sum of the cell to average of the cell. Thank you
