Forum Discussion
Power Query in Excel - Cell to Html Link
Hello Guys,
i`m new here and hope someone can help me.
I have a PowerQuery table which reads data from several normal tables, including IP addresses and I want to make them clickable, for sorting the IP addresses are always filled out, an example: 001.001.001.001
How can I make each row of a column a hyperlink in PowerQuery, the link should be hidden?
Text to display: 001.001.001.001 (same as before)
Clickable link: http://1.1.1.1
Thank you for this great forum.
5 Replies
feCreation , Create a new column with URL and mark that URL column. and then use the URL formatting option
refer
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables
Hello and thank you for the answer, but i got a problem.
if i do it like you say, the text "http://" is allways shown, but i only want to see the Title of the Hyperlink
Hi feCreation ,
No. You can use a link icon. If you need custom text for your hyperlinks and your list of URLs is short, consider using a text box instead.
Best Regards
Community Support Team _ chenwu zhu
Your Solution is only for PowerBI, i'am using PowerQuery inside Excel, there is no such option.
