Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
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 Regards
Saud 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.
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.
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?
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 Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
I noticed that the following option "Apply drill down filter to" is diable:
I deleted the pages and recreated them again, but I still don't have the drill-through option in my menu.
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
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)
Thank you. I deleted your page and recreated them and I can get the Drill through option
try to recreate the page
Make sure the relationship is this
Make sure when you drag the product_id is from the Product Table and not the Product History
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
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:
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 don't have such an option, what I have in page information is as follows:
I also selected the cross-report drillthrough in the options and settings, Report setting
May be you should update your desktop version, also check if the below option is checked or not
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |