Редагувати

Поділитися через


Add hyperlinks (URLs) to a table or matrix

APPLIES TO: Power BI Desktop Power BI service

This topic explains how to add hyperlinks (URLs) to a table or matrix visual. The process starts in Power BI Desktop where designers add hyperlinks (URLs) to a semantic model. Once the semantic model contains the hyperlinks, you can add them to tables and matrixes in Desktop or the Power BI service. Display the URL or a link icon, or format another column as link text. When report readers select a link, it opens in another browser page.

There is more than one way to add and format hyperlinks in visuals. For an alternate method, see Conditional formatting.

Table with hyperlinks

You can also create hyperlinks in text boxes in reports in the Power BI service and Power BI Desktop. And in the Power BI service, you can add hyperlinks to tiles on dashboards and to text boxes on dashboards.

You can format a field with URLs as hyperlinks in Power BI Desktop, but not in the Power BI service. You can also format hyperlinks in Excel Power Pivot before you import the workbook into Power BI.

  1. In Power BI Desktop, if a field with a hyperlink doesn't already exist in your semantic model, add it as a custom column.

Note

You can't create a column in DirectQuery mode. But if your data already contains URLs, you can turn them into hyperlinks.

  1. In Table view, select the column.

  2. On the Column tools tab, select Data category > Web URL.

    Data category dropdown list

    Note

    URLS must start with certain prefixes. See Considerations and troubleshooting in this article for the complete list.

  1. After you've formatted a hyperlink as a URL, switch to Report view.

  2. Create a table or matrix with the field that you categorized as a Web URL. The hyperlinks are blue and underlined.

    Blue and underlined links

If you don't want to display a long URL in a table, you can display a hyperlink icon Hyperlink icon instead.

Note

You can't display icons in a matrix.

  1. First, create a table with a hyperlink.

  2. Select the table to make it active.

    Select the Format icon to open the Formatting tab.

    Under Visual > URL icon, for Values, select On.

    Screenshot shows the U R L icon value set to On.

  3. (Optional) Publish the report from Power BI Desktop to the Power BI service. When you open the report in the Power BI service, the hyperlinks work there, too.

You can also format another field in a table as the hyperlink, and not have a column for the URL at all. In this case, you don't format the column as a Web URL.

Note

You can't format another field as the hyperlink in a matrix.

  1. If a field with a hyperlink doesn't already exist in your semantic model, use Power BI Desktop to add it as a custom column. Again, you can't create a column in DirectQuery mode. But if your data already contains URLs, you can turn them into hyperlinks.

  2. In Table view, select the column that contains the URL.

  3. On the Column tools tab, select Data Category. Make sure the column is formatted as Uncategorized.

  1. In Report view, create a table or matrix with the URL column and the column you're going to format as link text.
  1. With the table selected, select the Format icon to open the Formatting tab.

  2. Under Visual, expand Cell elements. For Apply settings to, make sure the name in the box is the column you want as link text. Locate Web URL, and set it to On.

    Screenshot shows the Web U R L setting with a value of On.

    Note

    If you don't see a Web URL option, in Power BI Desktop make sure the column that contains the hyperlinks isn't already formatted as Web URL in the Data Category dropdown box.

  3. In the Web URL dialog box, select the field that contains the URL in the What field should we base this on dropdown. Then select OK.

    Web URL dialog box

    Now the text in that column is formatted as an active hyperlink.

    Text formatted as hyperlink

Another way to add hyperlinks to your Power BI tables and matrixes is to create the hyperlinks in the semantic model before you import/connect to that semantic model from Power BI. This example uses an Excel workbook.

  1. Open the workbook in Excel.

  2. Select the PowerPivot tab and then choose Manage.

    Open PowerPivot in Excel

  3. When PowerPivot opens, select the Advanced tab.

    PowerPivot Advanced tab

  4. Place your cursor in the column that contains the URLs that you'd like to turn into hyperlinks in Power BI tables.

    Note

    URLS must start with certain prefixes. See Considerations and troubleshooting for the complete list.

  5. In the Reporting Properties group, select the Data Category dropdown and choose Web URL.

    Data category dropdown in Excel

  6. From the Power BI service or Power BI Desktop, connect to or import this workbook.

  7. Create a table visualization that includes the URL field.

Considerations and troubleshooting

URLs must start with one of the following:

  • http
  • https
  • mailto
  • ftp
  • news
  • telnet

Q: Can I use a custom URL as a hyperlink in a table or matrix?
A: 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.

More questions? Try the Power BI Community