Forum Discussion

LittleAnners_08's avatar
LittleAnners_08
Frequent Visitor
6 years ago
Solved

Using Conditional Formatting on Text value to show Icons - Icons Not showing

HI

I have Text columns that I need to use icons instead, based on warning status of each wording.

I have used a Conditional Column in queries to add a numeric value based on text, which works fine i.e "Critical "= 3, "Warning" = 2, "Ok"= 1 and n/a = 4, I then changed the format of the column to decimal number.

 

I then add the new column into my table. Numbers show up fine.  However, when I go to add the icons to these numbers, see attached image, and press ok, NO icons appear in my table, numbers still just show.  I have gone back over my steps above and everything seems to be in order, so bit lost as to why the icons are not showing.  Any help would be appreciated.

 

Thanks

 

Ann

 

  • LittleAnners_08 

    issue could be in sum as summarization parameter. it depends on your data model and visual. 

    But if you try to use average, in or max, it maybe will work ok

  • Thanks az38 !!  Changing it to just "Max" instead of sum, worked! Thanks so much, always simple when you know how!

5 Replies

  • az38's avatar
    az38
    Community Champion

    LittleAnners_08 

    issue could be in sum as summarization parameter. it depends on your data model and visual. 

    But if you try to use average, in or max, it maybe will work ok

    • LittleAnners_08's avatar
      LittleAnners_08
      Frequent Visitor

      Thanks az38 !!  Changing it to just "Max" instead of sum, worked! Thanks so much, always simple when you know how!