Forum Discussion
Alta88
Helper IV
Helper IVAdding 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...
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
Super User
Super UserI think it is only available in the table visual, not a matrix.
Alta88I'm not sure I understand. I had the table visual open when I clicked in the fields to select Conditional Formatting. Please advise.