How to use hyperlink as drill through in PowerBI

[sribmc]

Hi Team,

I have 1st page :

Zone

Z1

Z2

Z3

Z4

Z5

2nd page contains 

Zone	State
Z1	HNK
Z1	JLK
Z1	MNK
Z2	LL1
Z3	LL2
Z4	LL3
Z5	LL4

I need hyperlink on zone at 1st page 

when I select Z1 it needs to redirect to Page 2 and filter need to happen on url 

expected out put on page 2

Zone selected : Z1

Zone    State

z1         HNK

z1         JLK

z1       MNK

NEED HELP ASAP

[aduguid]

Hyperlink from a Value (Using Bookmarks):

If you want to hyperlink directly from a value (e.g., a data point in a table or chart) to another page, you need to use bookmarks and a bit of DAX:

• Create a bookmark for each page you want to navigate to. To do this, go to the View tab, select Bookmarks Pane, and then create a bookmark for each page.

• Create a measure to navigate to the desired bookmark based on the selected value. 

NavigateToPage = 
IF(
    SELECTEDVALUE(Table[Column]) = "Value1",
    "Bookmark1",
    IF(
        SELECTEDVALUE(Table[Column]) = "Value2",
        "Bookmark2",
        "DefaultBookmark"
    )
)

[sribmc]

@aduguid here we need to filter as well other than just navigation

[aduguid]

You could format the hyperlink to pass the value 

ProductLink = "ReportSection?filter=Product/ProductName eq '" & 'Product'[ProductName] & "'"

[sribmc]

Can you please send pbix file of sample one which works above scenerio that would be helpful I have tried this but not working

[foodd]

Please elaborate futher.    Some general questions:   

• Have you already incorporated Bookmarks, Page and Bookmark Navigators?   
• Is the report consumer navigating within the same report and visuals or is your intention to launch a different but related report?   
• In what way is the consumer interacting with the visuals?   Meaning, is this a Dashboard, Report, App, Embedded... 
• Are you intending that the report consumer have a bread crumb trail somewhere in the canvas layout?

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

[sribmc]

@foodd I have 1st page :

Zone

Z1

Z2

Z3

Z4

Z5

2nd page contains 

Zone	State
Z1	HNK
Z1	JLK
Z1	MNK
Z2	LL1
Z3	LL2
Z4	LL3
Z5	LL4

I need hyperlink on zone at 1st page 

when I select Z1 it needs to redirect to Page 2 and filter need to happen on url 

expected out put on page 2

Zone selected : Z1

Zone    State

z1         HNK

z1         JLK

z1       MNK

These need to be developed on report

[aduguid]

Can you use the drill through option?

[sribmc]

we know drill through option but user needs that work on click of hyperlink

[sribmc]

please help us asap

[kuruba1289]

I too have same requirment. Could you tell me approach if you have done it.

[kuruba1289]

Do you have any approach for that