Converting a URL Link Field in Power BI from Text to Hyperlink to Icon

Leave a comment

In Power BI, your data may contain a hyperlink to a webpage. For example, consider the query of Companies below that has a company name and website field:

In Power BI, selecting these fields on a report will produce a text field for the hyperlink:

To tell Power BI that this is a URL link, select the field, go to Modeling and change the Data Category to Web URL:

These fields can now be selected:

Now, if you want to make this an icon, which can look a little cleaner, select the field and select Format, then under Values set URL Icon to On:

This will now display the hyperlink as an icon, with the ability to click on it to open the linked webpage:

Web page opened:

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, BI, Web, Cloud and Data Science.

carldesouza.comLinkedIn Twitter | YouTube

 

Leave a Reply

Your email address will not be published. Required fields are marked *