Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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>"
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |