Hyperlink

[BeatriceHuyser7]

Good day,

I have a set of data in a table view, 1 person linked to eg 12 people. I want to do a hyperlink on the count 12 to display the 12 people on another tab. is that possible. Next person is linked to eg 5 people, and when selecting the 5 to display the 5 people on the different tab.

Thanks

[Fenil_Italiya · Accepted solution]

Hello, @BeatriceHuyser7 

Yes, this is possible in Power BI.

One option is to use Drillthrough. Create a separate report page with a table that displays the linked people, then add the Person field to the page's Drill-through filters. From your summary table, users can right-click a person (or the row) and choose Drill through to open the detail page. The page will automatically be filtered to show only the linked records for the selected person, whether that's 12, 5, or any other number.

If you prefer  without requiring a right-click, you can use Page Navigation together with a Button. Let the user select a row in the summary table, then click a "View Linked People" button to navigate to the detail page. As long as the page is configured to keep the current filter context (or uses Drillthrough), the detail page will display only the linked people for the selected person.

Both approaches work well, but if you want a seamless summary-to-detail experience, I'd recommend the Drillthrough option.

[v-aatheeque · Accepted solution]

Hi @BeatriceHuyser7 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

[BeatriceHuyser7]

Hi @v-aatheeque 

yes i did a drill through to the tab.

thank you everyone for assisting

[v-aatheeque]

Hi @BeatriceHuyser7 

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.

[Parchitect]

The answers from others are correct— this is a Drillthrough scenario rather than a normal hyperlink scenario.

A normal hyperlink on the count value will not automatically pass the selected person context to another report page in the same way Drillthrough does.

The usual setup would be:

1. Create a detail page with a table showing the linked people.

2. Add the main Person field to the Drillthrough filters well on that detail page.

3. On the summary page, make sure the Person field is part of the table row context.

4. The user can then right-click the person/count row and choose Drill through to the detail page.

That detail page will then show the 12 linked people for one person, 5 linked people for the next person, etc.

If you want a more “button/click” experience instead of right-click, you can also add a button and set its Action to Drill through. The user selects a row in the summary table, then clicks the button to go to the detail page with the selected context.

So short version:

- Hyperlink = not ideal for this

- Drillthrough = recommended

- Drillthrough button = best if you want a more guided user experience

🔍Parchitect
Solutions Architect · Microsoft Fabric Specialist

💡Helpful? Kudos are appreciated.
✔️Solved? Mark as Solution so others can find it faster.

[Kedar_Pande]

Don't use a hyperlink, use drillthrough.

• Make a second page with the detail table (the linked people).
• In that page's Drillthrough field well, drop the person field.
• On your main table, right-click the row, Drillthrough > go to detail page.

@BeatriceHuyser7

[Fenil_Italiya · Accepted solution]

Hello, @BeatriceHuyser7 

Yes, this is possible in Power BI.

One option is to use Drillthrough. Create a separate report page with a table that displays the linked people, then add the Person field to the page's Drill-through filters. From your summary table, users can right-click a person (or the row) and choose Drill through to open the detail page. The page will automatically be filtered to show only the linked records for the selected person, whether that's 12, 5, or any other number.

If you prefer  without requiring a right-click, you can use Page Navigation together with a Button. Let the user select a row in the summary table, then click a "View Linked People" button to navigate to the detail page. As long as the page is configured to keep the current filter context (or uses Drillthrough), the detail page will display only the linked people for the selected person.

Both approaches work well, but if you want a seamless summary-to-detail experience, I'd recommend the Drillthrough option.