Display status icon in table column

[VictorHuynh]

Hi!

I was wondering if there is a way to disaplay different icons/images in a table column depending on what value it contains?

I'm getting my data from a streaming dataset.

Best regards,

Victor Huynh

[v-ljerr-msft]

Hi @VictorHuynh,

Based on my test, an alternative solution could be that using the formula below to create a new column in your table. And in Modeling, set the data category to “Image URL”.

Column = IF(Table1[Status]=2,"http://sqlkover.com/wp-content/uploads/2017/02/thumbsup.png","http://sqlkover.com/wp-content/uploads/2017/02/thumbsdown.png")

Then you should able to display different icons/images in a table column depending on what value it contains, on the Table visual. 

Regards

[VictorHuynh]

Hi @v-ljerr-msft,

Thank you for your reply. 

It seems like when getting data from a streaming dataset most of the functions in Modeling are disabled. I only thing I could click on is the New Measure. So instead of creating a column I created a new measure  with a SWITCH statment instead. But unfortunately I could not set the Data Catagory for this new measure. It displays value (image-url) as text 😞 

Do you know of any other way I could solve this matter?

Getting data from streaming data set

The menu in Modeling (most of the functions are greyed out)

Best regards,

Victor