Forum Discussion
Create a hyperlink for each row in a column
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).
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.
1 Reply
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.