cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ahpitre Helper III
Helper III

Display short URL

I would like to display in a Table visual a value from a column, but make it a URL. For example :

 

I would like to display this :

 

6585767

 

But when user clicks the URL he is taken to this :

http://companyesite.com/account/customerhome.aspx?accid=6585767

 

Also, if possible, can this be done so URL opens in a separate Window/Tab? I normally do this in SSRS reports via using : 

 

="javascript:void(window.open('URL...

1 REPLY 1
rohit_acharya
Frequent Visitor

Re: Display short URL

You can use the concatenate function and create a new column CONCATENATE("http://companyesite.com/account/customerhome.aspx?accid=",[account_id]) and create a new field. You can then embed this in a table view and then enable the URL icon in the formatting section of the table.

 

The article below will give you a detailed visual explanation of how to enable the URL Icon in your table which will replace the long text into a nicely formatted icon which the users can click.

http://analyticsavenue.com/power-bi-shorten-hyperlink-url/

By default the link opens in a new tab so you dont have to worry about that either. 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors