Forum Discussion
How 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 ...
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"
)
)
