Power Query in Excel - Cell to Html Link

[feCreation]

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.

[amitchandak]

@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

[feCreation]

Your Solution is only for PowerBI, i'am using PowerQuery inside Excel, there is no such option.

[feCreation]

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

[v-chenwuz-msft]

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

[feCreation]

Hi @v-chenwuz-msft 

do you have some pictures for me to understand where are the options and how it should look like in PowerQuery Editor?