Forum Discussion
Insert a page navigation link on a table visual
Hi guys!!
I would like to create a link on a specific table on my report page to link to other page with related information.
I know how to insert a web url link , but I do know how we can add a page navigation link.
E.g. If a click on the responsable name will link to other report page ( the same way we use action/page navigation/ destination page) or maybe add another column to link it
Thanks all in advance!!!
Fernando
Hi again fbittencourt
You question us a bit vague.
Try give clear explanations with examples. You will get a quicker and better answers without misunderstandings
Try this link to learn about drill throughs
https://youtu.be/WdBeJ8j98ME?si=EGR0rNWgBTZrJDf5
And use thus link to learn about hyperlink columns in visuals
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables
Please be nice and click thumbs up because I am trying to help.
Also click [accept solution] if anything helps. You can accept multiple solutions for the same problem, which shows your appreciation.
Many thanks
Hi fbittencourt ,
Try this :Create Pages
Rename two report tabs:
MainPage
DetailsPage
Create Table on MainPage
Go to MainPage
Insert a Table visual
Add fields: Composants, Etat, Responsable, and Tickets.
Set up Drillthrough on DetailsPage
Go to DetailsPage
Find the Drillthrough filters pane on the right
Drag the field Composants into that paneThis enables drillthrough based on that field
Now insert visuals (table, chart, etc.) that will show filtered data
Add a Card to Show the Selected Composant
Create a DAX measure:
Selected Composant = SELECTEDVALUE('TicketsData'[Composants], "No Selection")- Click Insert - Card visual -Add Selected Composant measure to that card
Test the Drillthrough
Go back to MainPage
Right-click on any row in the table (e.g., “Analyse fournisseur”)
Click Drillthrough → DetailsPage
You’ll land on DetailsPage, filtered to that selected row
You’ll see the card shows Analyse fournisseur.
Please find the attached pbix file for your reference.
If this helps, kindly click "Accept as Solution" and give a "Kudos" so others can benefit. Let me know if you need further assistance!Thank you,
Tejaswi.- Click Insert - Card visual -Add Selected Composant measure to that card
9 Replies
Hi fbittencourt,
Wanted to let you know that at visual stage page navigation is won't work. However Power BI has wonderful feature called drill through, using this you can navigate the specific person details in another page.
https://radacad.com/master-detail-design-with-drillthrough-filter-in-power-bi/Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.Try this ....
Create 4 pages in your Power BI report (Page1, Page2, Page3 and Home)
Open the Home page.On the top menu bar click on Insert > Buttons > Navigator > Page Navigator
This will crate a horizontal menu.
Go into the visual formatind menu and change the Grid Layout to Vertical.
Stretch the visual size.
Use the Pages and Show option to pick and chosse which pages you want in the menuUse the Formating options to change colours and shapes, to create a really cool menu.
Please be nice and click the thumbs-up because I have tried to help.
And click the [accept solution] button if it works.
You can accept solution from multiple members for the same problem.
Thank you !
Hi fbittencourt ,
Thanks for reaching out to the Microsoft fabric community forum.
Create PagesCreate four report pages:
-
Home
-
Page1
-
Page2
-
Page3
(You can rename each by double-clicking the tab names at the bottom.)
Add Visuals to Each Page
-
On each page, drag a Table or Card visual.
-
Use the sample table.
-
Add a page filter like:
-
PageName is Page1 (on Page1),
PageName is Page1 (on Page2), etc.
This helps visually confirm which page you're on.
Add the Page Navigation Menu
-
Go to the Home page.
-
Click Insert > Buttons > Navigator > Page Navigator.
-
A horizontal menu appears.
-
Select the menu → In Format pane:
-
Set Grid layout → Orientation = Vertical
-
Resize it to fit like a sidebar menu.
-
Find the attached pbix file for your reference.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find itBest Regards,
Tejaswi.
Community Support TeamHi Tejaswi,
Thanks for your answer, but I don´t wanna create a page navigator, I need to know if there´s a way to insert a field on a collumn from a table visual that links to other page from my report.
Imagine that If I click on analyse fournisseurs will take me to other page report, and give more details on other page.
tks again!!
Thanks for your answer, but I don´t wanna create a page navigator, I need to know if there´s a way to insert a field on a collumn from a table visual that links to other page from my report.
Imagine that If I click on analyse fournisseurs will take me to other page report, and give more details on other page.
tks
Hi fbittencourt ,
Try this :Create Pages
Rename two report tabs:
MainPage
DetailsPage
Create Table on MainPage
Go to MainPage
Insert a Table visual
Add fields: Composants, Etat, Responsable, and Tickets.
Set up Drillthrough on DetailsPage
Go to DetailsPage
Find the Drillthrough filters pane on the right
Drag the field Composants into that paneThis enables drillthrough based on that field
Now insert visuals (table, chart, etc.) that will show filtered data
Add a Card to Show the Selected Composant
Create a DAX measure:
Selected Composant = SELECTEDVALUE('TicketsData'[Composants], "No Selection")- Click Insert - Card visual -Add Selected Composant measure to that card
Test the Drillthrough
Go back to MainPage
Right-click on any row in the table (e.g., “Analyse fournisseur”)
Click Drillthrough → DetailsPage
You’ll land on DetailsPage, filtered to that selected row
You’ll see the card shows Analyse fournisseur.
Please find the attached pbix file for your reference.
If this helps, kindly click "Accept as Solution" and give a "Kudos" so others can benefit. Let me know if you need further assistance!Thank you,
Tejaswi.- Click Insert - Card visual -Add Selected Composant measure to that card
-
Hi again fbittencourt
You question us a bit vague.
Try give clear explanations with examples. You will get a quicker and better answers without misunderstandings
Try this link to learn about drill throughs
https://youtu.be/WdBeJ8j98ME?si=EGR0rNWgBTZrJDf5
And use thus link to learn about hyperlink columns in visuals
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables
Please be nice and click thumbs up because I am trying to help.
Also click [accept solution] if anything helps. You can accept multiple solutions for the same problem, which shows your appreciation.
Many thanks
Use this link to learn about hyperlink columns in a visuals
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables
This works so please be nice and click thumbs and [accept solution]. Thank you 😀😀😀
