Is it possible to remove certain drillthrough filter? If not, is there any alternatives?

[Yiyi]

Hello beautiful people! 

I have created a table in Power BI that filters to display only keywords that yielded zero results. Now, my objective is for a scenario that by clicking on any of these keywords, it would open another table, showing all the different search results associated with the selected keyword.

To achieve this, I attempted to remove the filter on the drill-through page. However, each time I select a new keyword from the original table, the filter gets reapplied automatically.

Could anyone guide me on how to resolve this issue? Your help would be greatly appreciated!

Thank you! 💖

[parry2k · Accepted solution]

@Yiyi turn off "keep all filters" on drill thru page:

[parry2k]

@Yiyi sorry not sure what is the ask here, when you drill through to the page from the main page by clicking the keyword, yes it will filter your drill through page on that keyword, so what do you want on drill thru page?

[Yiyi]

Hello Parry, thanks a lot for your reply! 

I just do not want all the filters I have on the main page to be on the filtered page. In my case, I have the filter of result = 0 on my main page. However, the keywords that yielded no result might still yield results based on the search condition. So on the drill-through page, I want to have all the searches (with result = 0 or result != 0) to show with that specific keyword.