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

Blogs
11 Jun, 2024

How to create a routing rule set to route cases in Dynamics 365

In this blog we will discuss how to create a routing rule to automatically route the cases to queue in…

READ MORE
Blogs
06 Jun, 2024

Restoring Deleted Records in Dataverse Tables

In this blog post, I will be discussing how we can restore the deleted records from any table in Dataverse.…

READ MORE
Blogs
15 May, 2024

Associated Grid Control Component in Dataverse

The Associated Grid Control enables us to improve the simplicity and readability of forms by displaying related record details across…

READ MORE