How to Make a Clickable Link in Power BI

Power BI is an incredible tool for visualizing data, but a report often tells only part of the story. Adding clickable links to your dashboards transforms them from static displays into interactive hubs that connect users to external websites, detailed reports, or source documents. This article walks you through several easy methods for creating clickable hyperlinks in Power BI, whether you need them in a table, an interactive button, or even an image.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Bother with Links in Your Power BI Reports?

Before jumping into the "how," let's quickly cover the "why." Integrating hyperlinks directly into your reports makes them significantly more powerful and user-friendly. Instead of just presenting a number, you can provide a direct path for action or further exploration.

• Provide Deeper Context: Link directly to source documents, project management pages, or external articles that explain the data.
• Connect to Other Reports: Guide users to other related Power BI reports or dashboards, creating a seamless analytical experience.
• Drive Action: Link a product ID to its product page on your e-commerce site, or a sales lead to their profile in your CRM.
• Increase Efficiency: Save your team time by putting all necessary resources right inside the report, eliminating the need to search for information elsewhere.

In short, links turn your report into a functional application, not just a picture of your data.

Foundation: Tell Power BI Your Data is a URL

Before you can make a link magically appear in a visual, you need to properly classify the data in your model. Power BI needs to know that a specific column of data contains web addresses. If you skip this foundational step, Power BI will just treat your URLs as plain text.

Here’s how to set it up:

1. Navigate to the Data view by clicking the table icon on the left-hand navigation pane.
2. Select the table that contains your URL column from the Fields pane on the right.
3. Click on the header of the column that contains your URLs (e.g., 'Website', 'ProductURL', etc.).
4. A Column tools tab will appear in the top ribbon.
5. In the 'Properties' section of this tab, click the Data category dropdown menu.
6. Select Web URL from the list.

That’s it. You’ve now told Power BI that this column should be treated as a hyperlink. Now, when you use this field in specific visuals, you'll get the clickable behavior you want.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Adding Clickable Links in Tables and Matrices

The most common place to add links is within a table or matrix visual. This is perfect for displaying a list of products with links to their pages or company names linked to their websites.

Step-by-Step Instructions

1. Return to the Report view (the top icon on the left pane).
2. Select the Table or Matrix visual from the Visualizations pane.
3. Drag the column you categorized as a 'Web URL' into the Columns (or Values, for a matrix) field-well for the visual.

Immediately, you’ll see that the URLs in your table are underlined and blue - they are now active hyperlinks. If you're working in Power BI Desktop, you'll need to Ctrl + Click to follow the link, but once published to the Power BI Service, it’s a standard single click.

Cleaning Up Long URLs with the URL Icon

Displaying full, messy URLs like <em>"https://www.yourstore.com/products/widgets/q4/blue-widget-pro-max-v2?source=report"</em> can make your tables look cluttered. Power BI has a handy built-in feature to solve this.

1. Select your table or matrix visual.
2. In the Visualizations pane, click the paintbrush icon to open the Format visual section.
3. Expand the Specific column section.
4. In the Apply settings to dropdown, choose your URL column.
5. You'll see a toggle for URL icon. Turn it On.

Your long, ugly URLs will be replaced with a clean, universal link icon. This keeps your report looking professional while maintaining full functionality.

Method 2: Creating Links in Text Boxes

Sometimes you need a simple, static link in your report's header or footer - perhaps one that points to your company intranet or a "Request Help" page. A text box is the perfect tool for this.

1. From the Insert tab on the top ribbon, click Text box.
2. Type the text you want users to see (e.g., "Visit our Sales Portal").
3. Highlight the text you just typed.
4. A formatting toolbar will appear. Click the link icon (it looks like a chain).
5. A dialog box will pop up. Paste your desired URL into the field and click Done.

Your text is now a clickable link. You can position this text box anywhere on your report canvas.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 3: Building Interactive Links with Buttons and Shapes

For a more app-like experience, you can use buttons, shapes, or images to trigger actions, including opening a web page. This method is incredibly versatile because the link can be either static or dynamic - changing based on what the user has selected in another visual.

Creating a Static Link with a Button

1. Go to the Insert tab on the ribbon, click Buttons, and select a style (e.g., a blank button).
2. Position the button on your report. With the button selected, go to the Format pane.
3. Expand the Style section and add your desired button text under Text (e.g., "Company Website").
4. Next, find the Action section in the Format pane and toggle it On.
5. Expand the Action settings. For Type, select Web URL from the dropdown.
6. In the Web URL field below, paste the static URL you want the button to open.

Now, when a user clicks this button, it will direct them to the specified webpage.

Creating a Dynamic URL with a Button

Here’s where it gets really interesting. Let's say you have a slicer with a list of products, and you want a button that says "View Product Details" which links to the specific page of the product currently selected. This requires a small DAX measure, but it's simpler than it sounds.

Step 1: Create the DAX Measure

1. From the Home tab, click New measure.
2. In the formula bar, type the following DAX formula. Be sure to replace 'YourTable'[URL_Column] with the actual name of your table and URL column.

Selected Product URL = SELECTEDVALUE('YourTable'[URL_Column])

The SELECTEDVALUE function checks if a single value is selected in the specified column. If so, it returns that value (your URL). If multiple or no values are selected, it returns blank, cleverly disabling the link.

Step 2: Connect the Measure to Your Button

1. Select the button you want to make dynamic.
2. In the Format pane, go to the Action settings (make sure it's turned 'On').
3. Set the Type to Web URL.
4. Instead of pasting a URL into the field, click the small fx button next to it (Conditional formatting).
5. A dialog box will open. In the Based on field dropdown, search for and select the measure you just created ("Selected Product URL").
6. Click OK.

Now, your button is context-aware! If a user selects "Blue Widget" in a slicer, the button's action will point to the URL for the Blue Widget. If they select "Red Widget," it will update to that URL instead. If nothing is selected, the button does nothing.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Wrapping Up with Some Best Practices

As you add links to your reports, keep these tips in mind to create the best possible experience for your users.

• Use Custom Tooltips: For buttons and shapes, go to the Format pane > Action settings and type a helpful message in the Tooltip field (e.g., "Click to view the live product page"). This tells users exactly what will happen before they click.
• Test Your Links: Always double-check your links in both Power BI Desktop and after publishing to the Power BI Service to ensure they work as expected.
• Make it Obvious: Don't make users guess what's clickable. Use descriptive button text and familiar visual cues like underlined text to signal interactivity.
• Consider your Audience: Will users be comfortable with links opening in the same tab or a new one? While this isn't directly controllable in Power BI, be mindful that it can disrupt their workflow.

Final Thoughts

Adding a clickable link in Power BI is a straightforward process that massively boosts the usability and power of your reports. Whether you’re embedding them in a simple table, a text box, or a dynamic button, hyperlinks bridge the gap between your insights and the resulting actions, guiding your team to the exact resources they need right from the dashboard.

Building effective reports ultimately comes down to getting clear answers quickly. Tools like Power BI offer deep control, but we built Graphed to simplify the entire reporting process. Instead of managing data categories and configuring visual settings, you can just ask a question in plain English like, "show me a dashboard of my top 10 products by revenue with their product page links from Shopify," and get an interactive, real-time dashboard built for you instantly. This helps your team spend less time building reports and more time acting on the data.