Forum Discussion
Helper IHow to use hyperlink as drill through in PowerBI
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
11 Replies
- aduguid
Memorable Member
Can you use the drill through option?
- foodd
Community Champion
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!
sribmcfoodd 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
- aduguidHyperlink 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" ) )
