Forum Discussion

jordanberry89's avatar
jordanberry89
New Member
7 years ago
Solved

Hyperlink Column

I have been banging my head against this for a little bit, and the crazy part is I have gotten it to work before but cant figure it out again.   I have a table in an excel file that has 20ish colum...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi jordanberry89,

     

    I test on my side and it can be recognized as hyperlink and open it on web browser.

     

    Please add "https//" prefix to your url string and set up 'Date Category' to 'web url' enable hyperlink feature, otherwise power bi will recognize it as normal text string.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi jordanberry89,

 

I test on my side and it can be recognized as hyperlink and open it on web browser.

 

Please add "https//" prefix to your url string and set up 'Date Category' to 'web url' enable hyperlink feature, otherwise power bi will recognize it as normal text string.

 

Regards,

Xiaoxin Sheng

jordanberry89's avatar
jordanberry89
New Member
7 years ago

Hey Anonymous,

 

Thank you for your help! I had the https:// added to the string, but what I was missing was setting the data category in the modeling view. The way I was trying to do it was going to the dataset and trying to cast it to a web url from a string. 

 

My dashboard is working as expected now! I will make your post as the answer.