Forum Discussion
Need Hyperlink for a table column
I am wondering if there is a way like SSRS clicking a word to go to a web site.
I queried some data from DB and one column named ID. Let's say it as below. In PowerBI, I want to click A then it will open http://A.COM when clicking B goes to http://B.COM. And so on.
| ID | URL |
| A | http://A.COM |
| B | http://B.COM |
| C | http://C.COM |
I do not want to show or click URL itself to achieve this. Just show ID data and hyperlink will be achieved when I click IDs.
Is there any way to do this? Thanks for your help.
To use the built-in Table visual, the URL column would have to be separate from ID. You could dynamically construct an HTML column using DAX and then add it to Power BI with the HTML Viewer custom visual.
HTML = "<td><a href='" & SampleTable[URL] & "'>" & SampleTable[ID] & "</td>"
3 Replies
To use the built-in Table visual, the URL column would have to be separate from ID. You could dynamically construct an HTML column using DAX and then add it to Power BI with the HTML Viewer custom visual.
HTML = "<td><a href='" & SampleTable[URL] & "'>" & SampleTable[ID] & "</td>"
But it is not clicable. when you click on it, nothing is opening.
