Displaying hyperlinked data in table or matrix visual in Microsoft Power BI


One of the very frequent asks in management reporting is to have the hyperlinked data (i.e., some text or image when clicked navigates to a webpage) displayed in table or matrix (pivot) reports. e.g., Project IDs displayed in a table view and when clicked opens up the webpage related to the Project ID in a browser.One of the very frequent asks in management reporting is to have the hyperlinked data (i.e., some text or image when clicked navigates to a webpage) displayed in table or matrix (pivot) reports. e.g., Project IDs displayed in a table view and when clicked opens up the webpage related to the Project ID in a browser.

Here is an example of how it is done in Microsoft Power BI Desktop. Here is a simple data set showing the content published on pivotronics.com website (content type, content title, publishing status and URL of the content). Here, you need to hyperlink the Content Title field to let you navigate to the corresponding webpage using the URL present in URL field.

Sample data set with hyperlinks and corresponding display text data
Sample data set with hyperlinks and corresponding display text data

Perform the below steps in Power BI Desktop to achieve the task, as shown in the below screenshot:

  • Select the table/matrix visual where you have this data set displayed. Step 1 in screenshot.
  • Click on the “Format” tab on “Visualizations” Pane. Steps 2 and 3 in screenshot.
  • Expand “Conditional Formatting” group and then select the field to be hyperlinked. In this case, Content Type field. Step 4 in screenshot.
  • Toggle-on the “Web URL” option. This displays the conditional formatting options dialogue. Step 5 in screenshot.
  • Select the desired field that has the hyperlink/URL to navigate, from the “Based on field” dropdown, leaving rest of the fields to be default selections. Then hit OK. Step 6 in screenshot.
Steps to enable hyperlinking a field in Microsoft Power BI Desktop
Steps to enable hyperlinking a field in Microsoft Power BI Desktop

Finally, with some field formatting to beautify it, the outcome will look like the below with hyperlinks enabled for Content Type field. When you click on any of the values in the content type field, you will be taken to its corresponding web page.

Final table visual outcome with hyperlinked field in Power BI Desktop
Final table visual outcome with hyperlinked field in Power BI Desktop

Happy learning 🙂

Your valuable comments are highly honoured..!!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Up ↑