Forum Discussion

AllanXu's avatar
AllanXu
Icon for Helper II rankHelper II
10 years ago
Solved

Any way to render clickable hyperlink in a report?

Hello,   Is there any way to to add a calculated hyperlink column to my report, so when user click on the link , a browser instance pop up and shows a web page with more details? This idea would wo...
Need Help
  • PowerBIGuy's avatar
    PowerBIGuy
    10 years ago

    Via Power BI desktop i was able to formart a hyperlink i had stored in a table as a cliclable hyperlink data type. I was able to apply the same formating on a calculated column. 

     

     

    Capture.JPG

PowerBIGuy's avatar
PowerBIGuy
Icon for Responsive Resident rankResponsive Resident
10 years ago

Via Power BI desktop i was able to formart a hyperlink i had stored in a table as a cliclable hyperlink data type. I was able to apply the same formating on a calculated column. 

 

 

Capture.JPG

  • rusmanicai's avatar
    rusmanicai
    New Member
    10 years ago

    HI,

    I am new at this Power BI thing, and I need some help somewhere along the same lines as the person who initiated this message.

    I am pulling Data from SQL and one of teh columns is teh path and filename to a file on my P drive (P:\CD PDF\BAS\BAS 1234.pdf.

     

    How can I add a new column that would apply formula "Hyperlink(Col1)" to all the records from my query?

     

    I tried typing "CDPDFLink = concatenate(concatenate("=hyperlink(",[CDPDF]),")")" and while it doesn't fail, it did not make my data a clickable hyperlink.

    I also change the column data type into weburl and that didn't work either.

     

    Any thoughts on how to accomplish this?

     

    Thank you,

     

    Julia.