Forum Discussion

mehrsa's avatar
mehrsa
Frequent Visitor
2 years ago
Solved

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...
Need Help
  • saud968's avatar
    saud968
    2 years ago

    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!

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

 

 

  • mehrsa's avatar
    mehrsa
    Frequent Visitor
    2 years ago

    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's avatar
      saud968
      Icon for Memorable Member rankMemorable Member
      2 years ago

      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

      • mehrsa's avatar
        mehrsa
        Frequent Visitor
        2 years ago

        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