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
07 Sep, 2023

Optimizing Storage with SubscriptionTrackingDeletedObject Cleanup

What is SubscriptionTrackingDeletedObject? The "SubscriptionTrackingDeletedObject" table is linked to the "DeletionService," which handles two types of cleanup: organization-wide and record-specific.…

READ MORE
Blogs
05 Sep, 2023

How to create real-time customer journeys in Dynamics 365 Marketing

Introduction: This blog will show how to create real-time customer journeys in Dynamics 365 Marketing. Customer journeys can be either…

READ MORE
Blogs
30 Aug, 2023

D365 CUSTOMER SERVICE: CUSTOMER 360 COMPONENT

Introduction: In Dynamics 365 (D365) Customer Service, the 'Customer 360' Component provides a comprehensive view of information and enables users…

READ MORE