Forum Discussion

VictorHuynh's avatar
VictorHuynh
New Member
8 years ago

Display status icon in table column

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

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    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. :smileyhappy:

    Regards

    • VictorHuynh's avatar
      VictorHuynh
      New Member
      8 years ago

      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