cross report drill through from report A to B to C back to A loses filter

[Anonymous]

Hi,

I have a Power BI report A which has a cross report drill through to report B (via Account No.), from report B, have another cross report drill through to report C (via Emp Id).  All works fine.
When I go from report A with Account No = 1 and drill through to report B, its filtered on Account No = 1 in report B, then I select Emp Id 123 on Report B and drill through to report C, its filtered on Emp Id 123 on report C.  
When I click on back on the IE browser, it goes to report B but loses the filter for Account No = 1 and since its a direct query with millions of records it times out.  I can click back twice when I am on report C on the IE browser, but doing this is not user friendly.  I also tried to create a "back" button on report C and copy the url for report A but opens up a new browser window and takes me out of Power BI App.

Is there a solution for this instead of having user click on back twice?
Thanks!

[Anonymous · Accepted solution]

Hi @v-zhouwen-msft 

Thanks for your response, you did point me to the right direction.  I recreated using small data set and it did retain the filter when I went from report A to report B to report C and then back to report B.  I compared my original report to the small data set report, I noticed that setting for "Persistant filters" was turned on my original report, when I turned off it retained the filter when going back to report B.  Thanks!

[v-zhouwen-msft]

Hi @Anonymous ,

Regarding your question, if you use the cross-report drill-through feature, you can only use the browser to return to the source report.

Have you created a Power BI app? After you store the three reports in the app,you can allow users to select the required report through the left navigation bar after drilling down. After my test, the filter conditions will be retained.

Publish an app in Power BI - Power BI | Microsoft Learn

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.