Forum Discussion
Navigate between pages and filter based on ID
Hi,
I would like to navigate from one row of a table to another page and filter the second page based on the ID of the row.
The first page has a table visual that shows the current data of products, like the following:
| Product_ID | Product_name | Price | Quality |
| 1 | appel | 12 | 1 |
| 2 | orange | 10 | 2 |
| 3 | strawberry | 15 | 5 |
Let's call it product page
On another page there is the history of these products, it is also in table visual, as follows:
| Date | Product_ID | Product_name | Price | Quality |
| 1.1.2023 | 1 | appel | 11 | 3 |
| 2.1.2023 | 1 | appel | 10 | 2 |
| 3.1.2023 | 1 | appel | 12 | 2 |
| 1.1.2023 | 2 | orange | 15 | 1 |
| 2.1.2023 | 2 | orange | 10 | 1 |
| 3.1.2023 | 2 | orange | 12 | 3 |
| 4.1.2023 | 2 | orange | 10 | 2 |
| 1.1.2023 | 3 | strawberry | 18 | 4 |
| 2.1.2023 | 3 | strawberry | 15 | 5 |
Let's call it product_history
the product_id is the same in both reports but the datasets are different.
I want to be redirected to the product_history page when I click on the second row of the product, in this example orange, and only show the data for orange, The ID can be used because it is the same on both pages.
I think I can't use cross-page drill-through, since in drill-through both pages should use the same dataset and it can show the detail of a summarized measure. My case is different.
How can I do this navigation
Hi check this PBIX file - https://github.com/saud968/Drill-through/blob/main/Drill%20through2.pbix
This will give you clarity. You can create the table visual from different tables, however, you have to pull drill-through data from the other table.
Best RegardsSaud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
Hi mehrsa
I looked at your pbix file, you seem to put the "product_ID" in "Product_History" into "Add drill-through fields here", which causes you to not be able to drill through.
Please try putting the "Product_ID" in the "Product" into "Add drill-through fields here".
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
15 Replies
The Power BI version is Version: 2.124.1052.0 and I select the "Modern visual tooltip", But still drill-through doesn't appear in the right click menu
- saud968
Memorable Member
Request you to please share a demo PBIX file to review
Here is the shared PBIX file:
General/Drill through.pbix at main · mehrsaFazli/General (github.com)
Hi mehrsa
I looked at your pbix file, you seem to put the "product_ID" in "Product_History" into "Add drill-through fields here", which causes you to not be able to drill through.
Please try putting the "Product_ID" in the "Product" into "Add drill-through fields here".
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mehrsa
I understand that you have some questions about drilling through. If there are fields associated with the two tables, so you can drill across pages.
Here's how I gave you about drill through:
Here's some dummy data
“product”
“product_history”
Create visuals on different pages
Put "Product_ID" in "product" into "Add drill-through fields here"
This way you can select the product in Page 1 and drill through to Page 2
If you want to go back to Page 1, you can use this button, this button will appear when you choose to open "Cross-report".
If you want to know more details, you can check out the link below:
Set up drillthrough in Power BI reports - Power BI | Microsoft Learn
Best Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Nono,
Does the right click that shows the drill-through work on the desktop?
because drill-throughs don't show to me. when I right-click, the following menu appears:
- saud968
Your page 2 go to Page Information Check what have you selected drill through when as a "Category" or "Summarized" Based on your selection you will see drill through.
If this helps accept as a solution
I deleted the pages and recreated them again, but I still don't have the drill-through option in my menu.
I noticed that the following option "Apply drill down filter to" is diable:
The drill-through only works when I create both pages based on the same table (data source).
In my example, I want to create two pages based on different tables, where one column is the same in both tables.
Does anyone have any ideas?- saud968
Hi check this PBIX file - https://github.com/saud968/Drill-through/blob/main/Drill%20through2.pbix
This will give you clarity. You can create the table visual from different tables, however, you have to pull drill-through data from the other table.
Best RegardsSaud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
