Need help with maintaining filters when using DrillThrough Pages

[Rnaval]

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

https://www.dropbox.com/scl/fi/mid0637x585fxdehe0qso/Tenable-Extract.xlsx?rlkey=6wgvytyrbmr7maaf121s...

[Anonymous]

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]

Not sure you understand the issue correctly, if you can now try and download the pbix and data file, you'll see the issue.

[Rnaval]

Try the new links below...

https://www.dropbox.com/scl/fi/tr5hfnm5dqt08xzgj34e9/VM.pbix?rlkey=2r5g493mb1dbxwzs7i6c6fkux&dl=0

https://www.dropbox.com/scl/fi/mid0637x585fxdehe0qso/Tenable-Extract.xlsx?rlkey=6wgvytyrbmr7maaf121s...

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]

Any update on this? 

[Rnaval]

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.