Forum Discussion
feCreation
4 years agoNew Member
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 sor...
amitchandak
4 years agoSuper User
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
4 years agoNew Member
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-msft4 years agoCommunity Support
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
- feCreation4 years agoNew Member
do you have some pictures for me to understand where are the options and how it should look like in PowerQuery Editor?