Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |