topic Display short URL in Report Server

Display short URL

Anonymous — Tue, 16 Oct 2018 14:42:14 GMT

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&colon;void(window.open('URL...

Re: Display short URL

rohit_acharya — Fri, 29 Mar 2019 03:19:36 GMT

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.