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

[LittleAnners_08]

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

[az38 · Accepted solution]

@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

[sanimesa]

@LittleAnners_08 I'd add that column in the table and see what actual value comes up in the context. 

[az38 · Accepted solution]

@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 · Accepted solution]

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

[Icey]

Hi @LittleAnners_08 ,

Glad to hear that. Please accept your reply as the solution. Your contribution is highly appreciated.

Best Regards,

Icey

[az38]

@LittleAnners_08 

good luck 🙂