Forum Discussion

rickylee's avatar
rickylee
Helper III
8 years ago

Drill through filter does not work

Hello,

I am a newbie in 'drill through', so I have created two pages with the exact information as stated in the attachments. I set the 'drill through' as salesorderid in the order table on page 2. Since one order has different assessments, there are six assessment_id in the assessment table.

Question 1:
When I am on page 1, I right click and drill through a salesorderid. Then I am being directed to page 2 but it only shows me one assessment_id. But there are six assessment_id per 1 salesorderid.  

 

Question 2:
On page 2, I click the 'back arrow' button. Nothing responds. How come?



Thanks,
Ricky

Need Help

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi rickylee,

    Question 1:
    When I am on page 1, I right click and drill through a salesorderid. Then I am being directed to page 2 but it only shows me one assessment_id. But there are six assessment_id per 1 salesorderid.  

     

    Question 2:
    On page 2, I click the 'back arrow' button. Nothing responds. How come?





    1. Please check if there is any option has been selected. With Drill through, we could get the focused page to get details that are filtered to that context. So it will show the filtered data, you may have a good look at when we need Drill through.

     

    2. You should hold down the "Ctrl" on your kryboard and click the "back arrow " button, then you will back to the page 1.

     

     

    If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best  Regards,

    Cherry