The Best Way to Add Hyperlink to a Text Column in Power BI

Recently, I was working on a Power BI report for a client. They wanted to create a report for their marketing team, where users can click on a visual and see more information related to that item.

In their dataset, they already have a URL column. The requirement was to show this URL in a user-friendly way, so when users click on it, they are redirected to the related page.

In this tutorial, I will show different ways to add hyperlinks in Power BI, including:

• Display a URL column as a blue underlined link in Power BI
• Add a hyperlink to an icon in Power BI
• Add a hyperlink to a text column in Power BI

Display a URL column as a Blue Underlined Link in Power BI

For this example, I have a dataset with a URL column and other related information. Check the screenshot below.

Now, I want the URL column in Power BI to display clickable blue underlined links in the report.

To do this, follow the steps below:

1. Open this Power BI Desktop and load your data where the Hyperlink value is Present.
2. Then go to the Table view and select the column. In the Column tools expand Data category.

3. From the dropdown value, select the Web URL.

4. Now go to the report view, then add a Hyperlink column to a table visual.

You will see that the URL values are displayed as blue underlined clickable links in the report.

Add a Hyperlink to an Icon in Power BI

Instead of showing a full URL, I want to show a clickable icon. When users click on the icon, it should open the related web page.

For this example, I am using the same dataset that contains a URL column.

1. Open Power BI Desktop and load your data.
2. Go to the Report view and add a Table visual. Now, drag the column that contains the URL into the table.

3. Next, select the table visual and go to the Format pane. In the Visual section, expand the URL icon and enable Values.

4. Once this option is enabled, the URL text will be replaced with a small link icon.

When users click on this icon, it will open the related web page. This method keeps the report clean and easy to read.

Add a Hyperlink to a Text column in Power BI

Now I want to add the web url to the campaign Name column instead of displaying the full URL.

To do this, follow the steps below:

1. Here, I will use the same table that we created above, if you can create a new table.

2. Select the table, then open the format pane.

3. Under the Visual section, expand the cell element and enable Values.

4. Select the column name you want to add the web url link series, then enable Web URL.

5. It will open a pop-up where you select the Website URL under “What field should we base this on?”. Then select OK.

6. Now, the Campaign Name text will appear as a clickable link, and when users click on it, they will be redirected to the related web page.

In this tutorial, we learned different ways to add hyperlinks in Power BI. First, we saw how to display a URL column as a blue underlined clickable link. Then, we learned how to show a hyperlink using an icon to keep the report clean. Finally, I covered how to add a hyperlink to a text column so users can click on text instead of seeing the full URL.

You may like the following Power BI tutorials:

• Remove Leading Zeros in Power BI
• Change Data Type in Power BI
• Sort Slicer by Another Column in Power BI
• Remove Filters in Power BI DAX
• Add an Empty Column in Power BI