Remove filter of drill through

[Anonymous]

Hi,

I have 3 pages in my report. In the first page, project ids are listed. In the second page, the members having that project id and the sum of their week wise effort for that particular project is shown by drill through from the project id in first page. On drilling through each member in the second page, I need to see efforts in all projects of that member in the third page. But currently, the effort is shown only for that project selected in the first page.

Is there any way to clear the Project Id filter shown above when drilling from second page to third page?

Any help is greatly appreciated. URGENT

Thanks,

Anjitha.

[v-robertq-msft]

Hi, @Anonymous 

According to my test, if you used the cross-page drill through to navigate to another page, the page will automatically be filtered to show information about the data point on which you right-clicked, and this is by design, which is explained in the official document:

Therefore, if you want to clear the filter when drilling through to another page, I think the only way is to create a bookmark button.

You can clear the filter on the page3 first, and add a bookmark to this page.

Then create a button in the page 2 to nevigate to this bookmark, like this:

Set up drillthrough in Power BI reports

How To Add A Button Using Bookmarks In Power BI

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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

[Anonymous]

Hi, @v-robertq-msft 

I wanted to avoid having to use bookmark to go to another page for drill through. But your solution seems to be the only work around for this issue.

Thanks for your help!

Regards,

Anjitha

[v-robertq-msft]

Yes, I guess so.😂

[v-robertq-msft]

Hi, @Anonymous 

What’s the type of your “ProjectId” filter? Is it a page-level filter or a report-level filter?

If you want to clear the Project Id filter when drilling from the second page to the third page, I think you should use the page level filter to filter the Project Id on the second page and clear the filter on the third page. Like this:

And you can achieve your requirement.

One blog about understanding Filters in Power BI

Thank you very much!

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[Anonymous]

Hi @v-robertq-msft ,

The filter that I showed above is not from the Filters Pane. When I drillthrough from first page to second page, the field from which I drilled through in the first page, appears a filter in the second page just below the Cross Report Drill Through Option as shown below-

I hope to have provided clarification,

Thanks for you reply, awaiting a solution.

Regards,

Anjitha