Forum Discussion

lancen's avatar
lancen
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Creating a Hyperlink in a table for a standard text column

Is it possible in a table to have a column of standard text from your dataset, but have that column be clickable based on a 2nd column in your dataset that is configured as a hyperlink?  Similar to <ahref="webaddress">Click Me</a> in html?

 

Thanks

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

    I don't see how that could work given the existing tools. For example, doing this doesn't work if you create a column and tell it that it is a web url or image url. You would need some way of flagging it as HTML and have Power View smart enough to render it as HTML.

     

    Column = CONCATENATE(CONCATENATE(CONCATENATE(CONCATENATE("<a href=",[url]),">"),[text]),"</a>")

    • zaforir2002's avatar
      zaforir2002
      Icon for Helper I rankHelper I
      10 years ago

      Hi there,

       

      I'm also after the same solution but can not figure it out how to flag the column as HTML.

       

      Regards,

      Zafor.

    • zaforir2002's avatar
      zaforir2002
      Icon for Helper I rankHelper I
      10 years ago

      Hi there,

       

      I have the same query how to flag a column as HTML.

       

      Regards,

      Zafor.