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.
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.
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.
Happy learning 🙂
