How to Show URL Icon in Power BI

Showing raw website links in a Power BI report is functional, but it often looks messy and takes up far too much space. Swapping those long URLs for a clean, clickable icon not only improves the look of your dashboard but also makes it far more intuitive for your users. This article will walk you through, step-by-step, how to replace text URLs with clickable icons in your Power BI tables and visuals.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Bother with URL Icons?

Before jumping into the "how," let's quickly cover the "why." Integrating icons into your reports isn't just a cosmetic change, it serves several practical purposes that enhance the overall quality of your work.

• Better User Experience (UX): An icon is a universal shortcut for "click here." It immediately tells your users that an action is available, making your reports easier to navigate without explanation.
• Saves Valuable Space: URLs can be incredibly long, stretching your table columns and forcing your users to scroll horizontally. A compact icon keeps your tables and matrices tidy and saves precious dashboard real estate.
• Professional Design: Clean, consistent icons make dashboards look more polished and professional. It shows an attention to detail that elevates your report from a simple data table to a well-designed analytics tool.

What You'll Need First

To follow along, you only need a couple of things ready to go:

• Power BI Desktop: This guide is for the desktop application, where you build your reports.
• A Data Source with URLs: Your dataset needs a column that contains full, valid web addresses (e.g., https://www.yourstore.com/product-page).
• An Icon Image URL: You need a direct link to the icon you want to use. The image must be hosted online where it can be publicly accessed. You can find excellent, free-to-use icons on sites like Flaticon or Icons8. For best results, use an SVG file type, as they scale perfectly without losing quality. Once you find an icon, right-click on it and select "Copy Image Address" to get the direct URL.

Step-by-Step: Adding Clickable URL Icons in Power BI

Now, let's get to the fun part. We'll break down the process into clear, easy-to-follow steps.

Step 1: Load Your Data

First, get your data into Power BI Desktop. Whether it's from an Excel file, a database, or a web source, the process starts the same.

For this example, imagine we're working with a simple table of products that contains a Product Name and a Product URL.

1. Click on Get data from the Home ribbon.
2. Select your source (e.g., Excel workbook) and load it into your report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Set the Data Category for Your URL Column

This is a critical step that many people miss. You need to tell Power BI that the text in your URL column is actually a web link. This doesn't change how it looks, but it changes how Power BI understands it.

1. Go to the Data view by clicking the table icon on the left-hand navigation bar.
2. Click on your data table to view its contents, then select the column that contains your URLs (e.g., Product URL).
3. The Column tools tab will appear in the top ribbon. In the Properties group, find the Data category dropdown.
4. Change the selection from Uncategorized to Web URL. A small link icon will appear next to your column name in the Fields pane, confirming the change.

Your URLs are now ready to be used as actual hyperlinks, not just plain text.

Step 3: Create a New Column for the Icon

Your original column contains the destination links. Now we need to create a separate column that will hold the icon image. We'll use a simple DAX formula to create a calculated column.

1. While still in the Data view, make sure your table is selected.
2. In the Column tools tab, click on New column.
3. The formula bar will appear. Enter a new DAX expression. You'll name your column and provide the URL for your icon. Paste the icon image URL you copied earlier inside the quotation marks.

Link Icon = "https://cdn-icons-png.flaticon.com/512/2802/2802811.png"

Press Enter. A new column named "Link Icon" will be added to your table, and every single row will have the exact same icon URL in it.

Step 4: Set the Data Category for the Icon Column

Just as we told Power BI that our original Product URL column was a web URL, we now need to tell it that our new Link Icon column contains links to images. This tells Power BI to render the image instead of displaying the text link.

1. With your new "Link Icon" column selected, go back to the Column tools tab.
2. In the Data category dropdown, select Image URL.

Step 5: Add the Icon to Your Table Visual

With the data configured, it's time to build the visual. Switch back to the Report view (the bar chart icon in the top left).

1. Select a Table or Matrix visual from the Visualizations pane and add it to your report canvas.
2. From the Data pane, drag some fields into your table fields, like Product Name. Do not drag the original Product URL column in yet.
3. Now, drag your new Link Icon column into the table. Power BI will automatically recognize it as an image URL and display your chosen icon in every row.

You now have a table with a non-clickable icon. The final step is to bring it to life.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 6: Make the Icon a Clickable Hyperlink

This is where we connect the visual with the functionality. We'll use conditional formatting to tell Power BI: "When someone clicks the icon in the Link Icon column, open the corresponding URL from the Product URL column."

1. Select your table visual.
2. In the Visualizations pane, click the Format icon (the paintbrush).
3. Expand the Cell elements section.
4. From the Apply settings to series dropdown, choose your icon column (e.g., Link Icon).
5. Find the Web URL option and toggle it to On.
6. The Web URL card will expand. Click the fx button next to it to open the conditional formatting dialog.
7. On the next screen, configure the following:

• Format style: Set this to Field value.
• What field should we base this on?: This is the key part. Select your original URL column containing the destination links (e.g., Product URL).

1. Click OK.

And that's it! Your table now displays a clickable icon. You can test it in Power BI Desktop by holding down Ctrl and clicking an icon. When published, users can click it directly. We've successfully used one column for the visual (the icon) and another for the hyperlink behavior (the destination URL).

Advanced Tips and Troubleshooting

Here are a few quick tips to solve common issues and take your reports even further.

Icons Not Showing Up?

If you see a broken image link instead of your icon, double-check these things:

• Is your icon URL direct and publicly accessible? Paste it into your browser to ensure it loads.
• Did you set the Data Category for your icon column to Image URL?
• Are there any network or firewall restrictions preventing Power BI from accessing external URLs?

Improve Usability with Tooltips

An icon alone doesn't tell a user where they're going. You can easily add a tooltip that displays the destination URL on hover.

• Select your table visual.
• In the Visualizations pane, find the Tooltips field well.
• Drag your original URL column (e.g., Product URL) into the Tooltips well.

Now, when a user hovers their mouse over an icon, a tooltip will appear showing the full URL.

Adjusting Icon Size

If your icons appear too large or too small in the table, you have direct control over their dimensions.

• Select the table, go to Format your visual.
• Expand the Grid section.
• Find the Options and increase the Image height property. This will adjust the height of all images in your table, giving you the perfect fit.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Using Dynamic Icons

What if you want to use different icons based on a condition? For instance, one icon for social media links and another for website links? You can easily achieve this with a small change to your DAX formula in Step 3.

Instead of a fixed URL, use an IF statement. For example, if your URL contains "facebook.com", show a Facebook icon, otherwise, show a generic link icon:

Type Of Link Icon = 
IF(
    CONTAINSSTRING('YourTable'[Product URL], "facebook"),
    "https://your-url-for-facebook-icon.svg",
    "https://your-url-for-generic-link-icon.svg"
)

Remember to set the data category of this new dynamic column to Image URL just as before.

Final Thoughts

Replacing URLs with clickable icons is a straightforward technique that dramatically improves the professionalism and user-friendliness of your Power BI reports. By using data categories and a simple touch of conditional formatting, you can create cleaner, more engaging dashboards that your audience will find easier to use and understand.

While mastering tools like Power BI is incredibly rewarding, we know that spending hours in setup and formatting can sometimes keep you from the insights you need. At Graphed, we focus on helping you get those insights faster. We make it easy to connect your data sources and use simple, natural language to build real-time dashboards automatically - no DAX or conditional formatting required. If you're looking for a faster path from question to answer, give Graphed a try and let the AI do the heavy lifting for you.