Forum Discussion

Alta88's avatar
Alta88
Icon for Helper IV rankHelper IV
4 years ago
Solved

Adding Hyperlinks to a Table

We send out daily reports to another team so the managers can relay any errors cited during our audits. The trouble is, the IDs to the accounts we review are dead - they can't take the user back to t...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    You can create a measure that builds the URL to use.  In my example I have one that builds a URL to the nih.gov site using a drug code.

    Drug Search NIH =
VAR _DrugCode = SELECTEDVALUE ( vDRUGCODE[Drug_Code] )
RETURN
IF ( NOT ISBLANK ( _DrugCode ),
"https://mor.nlm.nih.gov/RxNav/search?searchBy=NDC&searchTerm="& _DrugCode)

    Then you use conditional formatting on the field and set this as the Web URL.

    That will make it a clickable link in the report:

     

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

I can't fugure out why the 'Web URL' conditional formatting option is not appearing for you.  It is there for me on field types of text or date/time so it's not that.  It's there even before I create a url measure.
If you create a new blank report and pull in some of the same data is the option available in the new one?  It seems there is a bug that can pop up in certain files.

https://community.powerbi.com/t5/Desktop/Web-Url-Conditional-Formatting-Unable-to-Select-Field/td-p/1825825