Power BI

Under Review

allow url from one column to be specified as hyperlink for another column

Vote (241)

Pedro Innecco on 27 Nov 2015 03:44:42

Suppose that I have a table that holds product information. One particular column (column A) has a URL value that points to the product page, while another column (column B) holds the product name.

What I am suggesting is that we could customise a model so the URL of column A could be used to make column B (the product name) a hyperlink.

This way if we present a table that in Power BI that shows product names, the product names would be clickable as a hyperlink. Then clicking on the hyperlink would open a browser window, which would show the product page.

Users could specify such relationship in a similar way they specify a column that is sorted by values of another column.

Administrator on 16 Nov 2019 07:50:59

We've started the work to allow you to conditionally format a column as a URL based on a value from another column.

Comments (19)

Comments (19)

38f5704d 7088-46c1-af9f-a9e96dc6da27 on 06 Jul 2020 00:13:34

RE: allow url from one column to be specified as hyperlink for another column

really need this feature!

454b324f 601d-4164-ab38-60b93bdaff21 on 06 Jul 2020 00:07:07

RE: allow url from one column to be specified as hyperlink for another column

Conditonal formattin Allows only first and last value to be linked to the text, how can make it dynamic based on the row value of the hypelink.

caaadc7a ace2-4287-ab59-0eebf0766458 on 06 Jul 2020 00:06:40

RE: allow url from one column to be specified as hyperlink for another column

This is great! Please let us know when it possible in tables.

41b608ec c537-4e50-b865-d11b6af11343 on 06 Jul 2020 00:04:41

RE: allow url from one column to be specified as hyperlink for another column

Thanks @Amanda! This is great news and something we'll definitely be putting into use.

1f7f2711 5819-e611-80e2-c4346bad91c4 on 06 Jul 2020 00:02:58

RE: allow url from one column to be specified as hyperlink for another column

Amazing news, Amanda. Thanks!

7862ef67 e1e2-4844-b9a9-99a19d7fa296 on 06 Jul 2020 00:02:48

RE: allow url from one column to be specified as hyperlink for another column

I would definitely love to see this!

4f649c3b 4075-44ac-8432-7f6d908bc520 on 05 Jul 2020 23:52:53

RE: allow url from one column to be specified as hyperlink for another column

This seems like a common sense feature. I realize that in a report that clicking on a field causes it to filter, but if you can make that control work on an Image/Web URL field, then you can make it work on a plain value/text field. This is a simple but important feature. And I just wasted 1 minute typing this because no one will care :)

9b4d7f90 f5f4-e911-a813-000d3a4f1cdd on 05 Jul 2020 23:52:47

RE: allow url from one column to be specified as hyperlink for another column

Yes, please include this

1e759205 14d0-416d-be64-f7fd7e075a68 on 05 Jul 2020 23:52:23

RE: allow url from one column to be specified as hyperlink for another column

I agree with this suggestion and would also like to see URLs supported that do not begin http:, https: or www so that a link can be made to an installed custom protocol handler that the user may have e.g. dynamicsnav:

a704204c 3d9f-4ebb-86f8-dba98a5ee376 on 05 Jul 2020 23:51:31

RE: allow url from one column to be specified as hyperlink for another column

This is handy in table, but this would be especially useful in Matrix.