How to Add Hyperlink in Power BI

Adding hyperlinks to your Power BI reports transforms them from static data displays into interactive and more user-friendly communication dashboards. This simple feature can guide your audience to deeper insights, provide crucial context, and make navigating complex reports a breeze. This article walks you through several methods for adding hyperlinks in Power BI, from basic table links to dynamic DAX-powered URLs.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Use Hyperlinks in Power BI?

Before jumping into the "how," it helps to understand the "why." Hyperlinks are a small feature with a big impact on the usability of your reports. They bridge the gap between summary data and the detailed information your users might need.

• Provide External Context: Link directly to relevant websites, internal documentation, project files on a shared drive, or specific pages in a SaaS tool. For example, you could link an order ID to its record in your e-commerce platform.
• Improve Report Navigation: Use buttons or text links to guide users between different pages in your report, creating a more intuitive, website-like experience instead of relying on tabs.
• Tell a Cohesive Data Story: Connect summary dashboards to detailed report pages, allowing users to drill down into the numbers that catch their attention without cluttering the main view.
• Offer Source Transparency: Include links to the source of your data, providing transparency and allowing stakeholders to verify information if needed.

The Simplest Method: Converting Text to URLs

The most straightforward way to add hyperlinks is when your data already contains a complete URL in a column. Power BI can automatically recognize and activate these links in visuals like tables and matrices.

Let's say you have a table of products and a column named ProductURL that contains the full address for each product's public page (e.g., https://www.yourstore.com/products/widget-a).

Here’s how to enable it:

Step 1: Go to the Data View In Power BI Desktop, navigate to the 'Data view' by clicking the table icon on the left-hand navigation pane.

Step 2: Select Your URL Column Find and click on the header of the column that contains your URLs (in this case, ProductURL). This will bring up the 'Column tools' menu in the ribbon at the top.

Step 3: Change the Data Category In the 'Column tools' tab, locate the 'Properties' group. You'll see a dropdown menu for 'Data category,' which is likely set to 'Uncategorized' by default. Click on it and select Web URL.

That's it! When you add this ProductURL field to a table or matrix visual in your report, Power BI will now automatically display the value as a clickable link. Users can click on it to open the URL in their default web browser.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customizing Hyperlinks in Tables and Matrices

Showing a full, clunky URL isn't always pretty or practical. Often, you want to display friendly text—like a product name or a call to action—and have that be the clickable link. While Power BI's direct capability here has evolved, the primary way to achieve clean linking within tables involves managing what is displayed versus what the link destination is.

Using the Web URL Icon for Clean Links

A great way to link descriptive text (like 'Product Name') without making the text itself the long URL is to use the 'Web URL' formatting option. This adds a small link icon next to your text, which users can click.

Let’s assume you have two columns: ProductName and ProductURL.

Step 1: Create a Table Visual On your report canvas, add a Table visual and drag your descriptive field (ProductName) into it.

Step 2: Open the Formatting Pane With the table selected, go to the 'Format your visual' pane (the paintbrush icon).

Step 3: Configure Cell Elements Expand the 'Cell elements' section. In the 'Apply settings to' dropdown, select the column you want to add the link to (in this case, ProductName).

Step 4: Turn On the Web URL Option Find the 'Web URL' toggle and switch it ON. New formatting options will appear just below the 'Web URL' title.

Step 5: Set the URL Field In the Web URL format options, make sure 'Based on field' is chosen for format style. Under that heading, choose the menu below where it says Which field should we base this on?. Then select the field containing your actual links (ProductURL) and click 'OK'.

Now, your table will display the product names, and each one will have a neat little link icon next to it that directs to the corresponding URL.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Creating Dynamic URLs with DAX

What if your URL doesn't exist as a single, neat column? Often, you need to build a URL dynamically by combining a base URL with a value from another column, like an ID or a search term. This is where DAX (Data Analysis Expressions) becomes incredibly powerful.

You can create a new calculated column that constructs the exact URL you need for each row.

Example 1: Combining Text and a Product ID

Imagine your data has a ProductID column, but not the full URL. You want to create links that follow the structure https://www.yourstore.com/products/[ProductID].

Step 1: Create a New Column In the 'Data view' or 'Report view', go to the 'Table tools' tab in the ribbon and click 'New column'.

Step 2: Write the DAX Formula In the formula bar that appears, you'll build your URL string. You can use either the CONCATENATE function or the ampersand (&) operator, which is more common and easier to read.

Here’s the formula using the ampersand:

ProductLink = "https://www.yourstore.com/products/" & 'Products'[ProductID]

This formula tells Power BI to create a new column named ProductLink. For each row, it takes the static base URL and appends the ProductID from that row.

Step 3: Categorize the New Column as a Web URL This is a critical final step! Just like in our first example, select your new ProductLink column and use the 'Column tools' menu to change its 'Data category' to Web URL. Now you can use this DAX-powered column in your visuals as a direct hyperlink.

Example 2: Creating a Dynamic Google Search Link

You can use this same technique to create utility links. For example, if you have a list of marketing keywords, you could generate a link to see the Google search results for each one.

SearchLink = "https://www.google.com/search?q=" & 'Keywords'[Search Term]

Adding Hyperlinks to Static Elements like Text Boxes and Shapes

Hyperlinks are not limited to data-driven tables. You can also add static links to text boxes, shapes, and images to create navigation and general information links, just like on a website.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Text Box Hyperlinks

This is perfect for adding links in headers or footers, like a link to your company’s home page or source documentation.

1. Navigate to the Insert tab in the ribbon and click Text box.
2. Type the text you want to become a link (e.g., "Company Website").
3. Highlight the text. A formatting toolbar will appear.
4. Click the link icon (the two chain links) in the toolbar.
5. Paste your desired URL into the field and click Done.

The text is now a clickable hyperlink.

Button, Shape, and Image Hyperlinks

Using shapes or icons for links makes your report more visually appealing and intuitive. You achieve this by configuring an "Action."

1. From the Insert tab, add a Button, Shape, or Image to your report canvas. For instance, you could add an "information" icon that will guide users to relevant data in a report page's table.
2. Select the object, and in the 'Format' pane, find and expand the Action section.
3. Toggle the Action switch to ON.
4. Under 'Type', select Web URL from the dropdown menu.
5. Another box will appear underneath the dropdowns labeled Web URL. You can paste a static URL directly into the URL field. For a dynamic target, click the fx button next to the input field and create or select a field or measure containing the URL such that selecting different slices in the reports modifies the link’s destination.

Creating Internal Page Navigation with Bookmarks

Finally, one of the most powerful uses for hyperlinks in Power BI is navigating within your report. Instead of forcing users to click through page tabs, you can guide them with buttons. An interactive title could lead to a detailed breakdown, for example. This is done with Bookmarks.

Step 1: Set Up & Create the Bookmark

1. First, navigate to the page you want to link to. Set up any filters or slicers on that page to define the exact state you want the user to see when they arrive.
2. Go to the View tab, check the bookmark setting in the section titled show panes to unveil bookmarks, where you can then click to open the Bookmarks pane.
3. Click Add and rename your new bookmark descriptively (e.g., "Sales Detail Drilldown").

Step 2: Link an Object to the Bookmark

1. Return to the page where you'll be placing your navigation button.
2. Insert a button or shape (e.g., a "Learn More" button).
3. With the button selected, go to the 'Format' pane and expand the Action section.
4. Toggle the Action to ON.
5. For 'Type,' select Bookmark.
6. A second dropdown will appear. Under the 'Bookmark selection box', select the bookmark you just made on the corresponding page earlier - "Sales Details Breakdown."
7. Optionally, add some text to the button's tooltip to tell users what it does on hover.

Users in the reading view can click your button and smoothly get sent on their predefined trip of data-analysis magic!

Final Thoughts

As you can see, hyperlinks are a versatile tool for making Power BI reports more contextual, navigational, and insightful. Whether you’re converting a simple data column, building a dynamic URL with DAX, or guiding users between pages with bookmarks, these techniques elevate a simple dashboard into a powerful, interactive analytics application.

Mastering these details is part of the steep learning curve for advanced BI tools, often requiring you to deep-dive into formatting settings or expression languages. At Graphed we aim to eliminate this friction entirely. Instead of spending hours learning how to create the visual you need, you simply ask for it in plain English. Imagine typing, "Show me a dashboard of my monthly sales with a link on each product name that goes to our Shopify page" and getting an interactive dashboard in seconds. Graphed automatically connects to your data platforms so you get straight to the insights - without the endless clicking about and code checking.