How to Add Hyperlink in Power BI Dashboard

Embedding hyperlinks in your Power BI dashboards transforms them from static reports into interactive, navigational experiences. This simple feature allows users to seamlessly move between report pages, access external websites, or open related documents directly from a visual. This guide will walk you through several straightforward methods to add clickable links to your visuals, text boxes, tables, and buttons, making your reports more dynamic and user-friendly.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Bother Adding Hyperlinks to Your Dashboard?

Hyperlinks are more than just a nice-to-have feature, they are a fundamental part of creating an intuitive and resource-rich report. They unlock several powerful capabilities:

• Improved Navigation: Guide users to other pages within your report or even to entirely different Power BI reports.
• Access to External Resources: Link out to company websites, SharePoint files, knowledge bases, or source documentation to provide context for your data.
• Deeper-Dive Analysis: Connect a high-level summary visual to a detailed underlying report, allowing stakeholders to explore data at their own pace.
• Action-Oriented Dashboards: Create "mailto:" links to trigger an email to a sales contact or a support team directly from the dashboard.

Method 1: Add a Basic Hyperlink in a Text Box

The quickest way to add a link to your dashboard is by using a text box. This is perfect for introductory text, report notes, or a "For more information" section.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Instructions:

1. Insert a Text Box: In Power BI Desktop, navigate to the Insert tab in the ribbon and click on Text box.
2. Add Your Text: Type the text you want users to see, for example, "Visit our company blog for Q3 insights."
3. Highlight and Link: Highlight the specific words you want to make clickable (e.g., "company blog"). A formatting bar will appear. Click the link icon (it looks like a chain).
4. Enter the URL: A small window will pop up. Paste the full URL into the field (e.g., https://yourcompany.com/blog) and click Done.

That's it! Your text is now a clickable link. It will automatically be styled with an underline to indicate it's interactive.

Method 2: Create Clickable URLs in Tables and Matrices

One of the most common use cases for hyperlinks is within a table or matrix visual. You might want to link from a product name in a sales table to its e-commerce page or from an employee name to their profile. Here are two ways to achieve this.

A. Using a Column That Already Contains URLs

If your data source includes a column with complete website URLs, you can easily make it interactive.

How to Set It Up:

1. Categorize Your Data: Go to the Data view or Model view in Power BI. Find and select the column that contains your URLs.
2. Set the Data Category: In the Column tools tab that appears at the top, find the Data category dropdown and select Web URL. This action tells Power BI to treat the text in this column as a hyperlink.
3. Add to Your Visual: Return to the Report view and add this field to your table or matrix. By default, it will display the full URL, and an arrow icon will appear when you hover over it.
4. (Optional) Use a Link Icon: A table full of long URLs can look messy. To clean it up, select your table, go to the Format your visual pane (the paintbrush icon), and expand the Cell elements section. Pick your URL column from the "Apply settings to" dropdown. You will see a Web URL toggle, turn it on. Just below that, click on the "fx" button for Icon to choose a cleaner link icon to represent the URL, making your table much tidier.

B. Building a Dynamic URL with DAX

Sometimes, your desired URL doesn't exist in a single column. For instance, you might need to combine a standard URL base with a unique ID from your data, like linking to a customer's record in Salesforce.

Example Scenario: Creating Salesforce Profile Links

Let's say your base URL for a customer profile is https://mycompany.salesforce.com/ and you have a CustomerID column in your 'Customers' table.

How to Set It Up:

1. Create a New Column: Go to the Data view, select your table, and click New column from the top ribbon.
2. Write a DAX Formula: Use a simple DAX formula to concatenate the base URL with the unique ID. The ampersand (&) is used to combine text strings.

SFDC Profile Link = "https://mycompany.salesforce.com/" & 'Customers'[CustomerID]

1. Set the Data Category: Once the new column is created, select it and set its Data category to Web URL, just as in the previous method.
2. Add to Visual: Now you can add your new "SFDC Profile Link" column to any table or matrix, and it will function as a clickable link.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 3: Turn Shapes and Images into Clickable Buttons

Shapes and images can serve as stylish, intuitive buttons for navigation or linking to external sites. This is perfect for placing a clickable company logo on every page or creating a "Help" button that links to documentation.

Step-by-Step Instructions:

1. Insert a Shape or Image: Go to the Insert tab. Choose a Shape (like a rectangle or oval) or an Image (like your company logo). Position and style it as you wish. You can add text to shapes to label your "button."
2. Activate the 'Action' Setting: Select the shape or image. In the Format pane on the right, you'll see a card named Action. Toggle it to On.
3. Configure the Link:

• For Type, choose Web URL from the dropdown.
• Under Web URL, paste the destination link.
• For Tooltip, type in helpful hover text, like "Click to visit our website." This is crucial for a good user experience!

Now your shape or image acts just like a button on a website, taking users to the URL you specified.

Method 4: Configure Native Power BI Buttons

Power BI offers built-in button visuals that have more styling options than simple shapes, including different looks for hover, press, and disabled states. They offer a more polished look for your user interface.

How to Use Them:

1. Insert a Button: Open the Insert tab, click the Buttons dropdown, and select a button type (e.g., Blank is a great starting point for custom designs).
2. Style Your Button: In the Format your visual pane, you can customize everything from the button's shape and color to its fill, icon, and text. You can also define how it looks on Hover or on Press for a truly professional feel.
3. Link the Button: Just like with shapes and images, select the button, find the Action card, and turn it on. Set the Type to Web URL and paste in your link. Don't forget to add a helpful Tooltip!

Graphed

Still Building Reports Manually?

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

Watch the Demo

Best Practices for Using Hyperlinks

To make your reports as clean and user-friendly as possible, keep these tips in mind:

• Always Use Tooltips: For any non-obvious link on a shape, image, or button, a tooltip is essential. It lets users know what will happen before they click, which builds trust and improves usability.
• Keep Tables Clean with Icons: For tables packed with data, avoid displaying long URLs. Configuring the hyperlink to show as a small, universal link icon saves space and reduces visual clutter.
• Maintain Consistent Design: If you use linked buttons or shapes, keep their styling consistent throughout your report. Users will learn to recognize your branded "button" and understand what is clickable.
• Test Every Link: Before publishing or sharing your masterpiece, go through and test every single link. Broken links frustrate users and can make a professional report feel sloppy. A quick check can save you from a major headache later.

Final Thoughts

Mastering hyperlinks in Power BI is a simple yet powerful way to elevate your reports from static data displays to interactive, connected analytical tools. By adding links to text, tables, shapes, and buttons, you can guide your users to deeper insights, external resources, and other relevant reports with a single click.

While fine-tuning every aspect of a Power BI report has its merits, building dashboards can sometimes feel slow and disconnected, especially with multiple data sources. Here at Graphed, we want to eliminate that friction completely. We built our AI data analyst so you can connect your marketing and sales data and use simple, natural language to instantly generate the real-time dashboards and reports you need - without spending hours picking through complicated BI tools. If you're looking for a dramatically faster way to get from data to decision, give Graphed a try.