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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
SarahHope
Helper II
Helper II

Can I hyperlink a columm with the urls from another column?

I have an ID column and an html column.  What I'd like is to hide the html column but have my report hyperlink the ID column using the html column as a map.  In the end, I hope that clicking the ID on the published report, will take viewers to the url for that ID.

 

Is that doable?

 

If so, can it be explaned in simple terms since I am fairly new to Power BI?

 

Thank you, 

Sarah

5 REPLIES 5
SarahHope
Helper II
Helper II

I think I figured it out myself!  It would not link to a numeric field.  But when I chose to link the title field to the URL field, it worked!

 

SarahHope
Helper II
Helper II

I have a URL colum called OrigID and I've followed conditional formatting instructions to a T but my ID column is still not a hyperlink.
My OrigID column is but that is a long ugly url.  I want just the ID hyperlinked and Ideally would like to hide or renive the OrigID from the visual.
I've folowed the instructions above and here.

Mkarwa-123
Resolver II
Resolver II

First you create hyperlinks using concat() dax function in your table using add new column. If it works then you can add in formatting pane URL icon to other columes.

SarahHope
Helper II
Helper II

I did find the conditional formatting for the ID field and I chose the "OrigID" field which contains my urls. 

I filled it out as follows, but as far as I can tell, my IDs are not hyperlinked.

SarahHope_0-1689802162570.png

 

@Mkarwa-123 I sort of figured it out.  On some tabs I am able to hyperlink the titles based on another column with the URLS, but in some I am not.  Oddly, when I try to add conditional URL formatting to the title on those tabs which are not working, a "total" row is added at the bottom without my consent.  I have to go the visualization paintbrush and manually turn that back off.  One one of them, I was able to hyperlink the ID, but not the title.  What is preventing this column from being hyperlinked in some cases even though the conditional formatting is the same on all tabs and every tab is using the same data?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors