knowledgecenter-breadcrum

Knowledge Center

17 Jun, 2020

Create One Or More Hyperlink Columns in Power BI

Posted on 17 Jun, 2020 by Admin, Posted in Power BI

Create One Or More Hyperlink Columns in Power BI Blogs

Create One Or More Hyperlink Columns in Power BI

In this, blog we will see how we can add hyperlink on one or more columns of Power BI Table.

To achieve this, we can use below property of table to add hyperlink on multiple columns of table.

Let see this in below example, we have created a power bi reports in which we will add the hyperlinks on account and contact fields and upon click of hyperlink fields CRM records will be opened as described in below steps.

  1. To use the “Web URL” property we must have the “URL” fields in our dataset. So, we have added Two Custom URL fields in Accounts dataset by editing the “account” dataset as shown below:
  1. Upon clicking of “Edit Query”, below screen will where we have selected the “Add Column” Tab to add the “Custom Fields”:
  1. In “Add Column” tab, click on “Custom Column” and upon clicking on the “Custom Column” below screen will appear in which we have added the CRM record URL:
     Upon Click on “OK” a New Custom Field will be created in dataset.
  1. Similarly, we have added the Contact URL field in Account dataset. After this, click on “Close & Apply “Button of “Edit Query” screen

    Now, we must change the datatype of “AccountURL” and “ContactURL” fields to “Web URL” as shown below:
  1. After this, select the Table Control and Search of “Conditional Formatting” as shown below:
  2. In the conditional formatting, click on “Web URL” Slider.
    Web URL Slider:

    and upon click on it below screen will appears:

    On Above screen, Select the Dataset, and Web URL fields that we have created previously (i.e. AccountURL, ContactURL). Here, we have selected the “AccountURL” field of account dataset.

    After clicking on “OK” the “AccountURL” field get mapped on “Account Name” field of Account dataset and creates the hyperlink on it as shown below:

    We can change the color of “Account Name” column to looks similar to hyperlink and to change this we have “Font Color” property as shown below:

    Similarly, we can add the hyperlink on other columns of Table control.

    As a result, hyperlinks get added on multiple fields of Table.

Comment

This is a Required Field

Loading

Recent Updates

Thumbnail D365 Sales
Blogs
09 Apr, 2025

What Is Dynamics 365 Sales? A Comprehensive Guide

What Is Dynamics 365 Sales? A Comprehensive Guide Microsoft has become a leader in business applications with its suite of…

READ MORE
Blogs
02 Apr, 2025

Quality is not just an option; it’s a responsibility

In the world of software development, testing is often seen as an optional phase, especially when there is no dedicated…

READ MORE
Thumbnail
Blogs
26 Mar, 2025

What is Power Virtual Agents: Exploring AI-Driven Virtual Chatbots?

What is Power Virtual Agents: Exploring AI-Driven Virtual Chatbots? In today’s digital landscape, businesses are constantly seeking ways to enhance…

READ MORE