Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
leroy773
Helper II
Helper II

Need to create hyperlink in power bi, i have a unique record id but need to add the URL

All,

 

I would like to add hyperlink to a report and dashboard.  Unfortunately my data set only has the record id and not the complete url.  How should I go about adding the starting portion of the URL to the record id in the data set? 

 

ex

 

xx00u9663ids

 

URL

 

https://salesforce.com/ + SFDC record ID

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

hi @leroy773

 

Create a calculated column to concatenate "Sales force URL" and your ID column

 

Change Data Category to WebURL

 

newcolumnLink.png




Lima - Peru

View solution in original post

5 REPLIES 5
Vvelarde
Community Champion
Community Champion

hi @leroy773

 

Create a calculated column to concatenate "Sales force URL" and your ID column

 

Change Data Category to WebURL

 

newcolumnLink.png




Lima - Peru

Hi @Vvelarde, I have another question. If I only want to show ID in that field but it actually includes the url, for example when I click ID 001 it will go to http://salesforce.com/001. Thank you.

Hi @kimzhao ,

 

Did you find a solution to your question ..?

Hi,

 

Does it have a solution?

 

BR

Hi,

 

That's exactly what I need
Have you got a solution for this?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.