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 UserThere are 2 'grid' visuals in PowerBI, Table and Matrix. Conditinal formatting can only be applied to the values section of a matrix so I just wanted to point that out. Are you using a Table or a Matrix?
Alta88Helper IV
Helper IVI see. Yes, I'm using a Table.