Forum Discussion

Harish85's avatar
Harish85
Icon for Helper III rankHelper III
1 year ago
Solved

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).    
  • MFelix's avatar
    1 year ago

    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.