Create a hyperlink for each row in a column

[Harish85]

Hi All,

I want to create a hyperlink in the column for each value, below is the image for reference,when I click on that link it should filter that particular value(183540).

[MFelix · Accepted solution]

Hi @Harish85 ,

When you refer to a hiperlink do you mean to access and external web page and to open it based on the filter or do you want to make a filter of another page in the report based on the specific value?

For the 1st option you need to create a measure or column where you add the value as a part of the text let's assume something like this:

The hiperlink is similar to this www.Google.com\filteredvalue=123456

Where 123456 is the value of your PO, you use the following code

Hyperlink = "www.Google.com\filteredvalue=" & SELECTEDVALUE(Table[Customer PO])

Don't forget to mark it has an web url

For the second option a page within the same report you need to use the drill trough option:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

This will allow you to move to another page.