Forum Discussion

HarveyM's avatar
HarveyM
Helper I
4 years ago
Solved

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 i...
Dashboards
  • HarveyM's avatar
    HarveyM
    4 years ago

    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 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

  • HarveyM's avatar
    HarveyM
    Helper I
    4 years ago

    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