Forum Discussion
Need help with maintaining filters when using DrillThrough Pages
Hi All -
I have a drill through page which is working fine but when I hit the return to main page, I lose all filters that were selected. Appreciate any help with this.
Thanks...Rohit
Here's a link to my pbix and the excel data.
https://www.dropbox.com/scl/fi/tr5hfnm5dqt08xzgj34e9/VM.pbix?rlkey=2r5g493mb1dbxwzs7i6c6fkux&dl=0
5 Replies
- Rnaval
Post Partisan
I wanted to mention that the issue is only found when I filter on a specific device or a vulnerability title in either of the two bar graphs and right click on the vulnerability title in the matrix to drill thru to the next page. When I return to the main page I lose the filter on the device or the vulnerability title.
- AnonymousNot applicable
Hi Rnaval ,
If I understand correctly, the issue is that you encountered the error when drilling through page.Please try the following methods and check if they can solve your problem:
1.Ensure that the drill through filters are correctly configured.
2.You can view the following link to learn information about the drill through page.
Use report page drillthrough - Power BI | Microsoft Learn
The provided pbix link does not open. Could you please provide more raw data(exclude sensitive data) with Text format? It would be helpful to find out the solution.
You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Rnaval
Post Partisan
Try the new links below...
https://www.dropbox.com/scl/fi/tr5hfnm5dqt08xzgj34e9/VM.pbix?rlkey=2r5g493mb1dbxwzs7i6c6fkux&dl=0
Not sure if you're understanding my issue correctly, If I have a filter on my main page and use a drill thru page, once I return to the main page, I lose that filter. This is only happening on the filters I set using one of the two bar charts.
If there's a way to take a snapshot of the filters on the main page, then restore them when you hit the back button from the drill thru page, that would work best.
- Rnaval
Post Partisan
Any update on this?
- Rnaval
Post Partisan
Not sure you understand the issue correctly, if you can now try and download the pbix and data file, you'll see the issue.