Drillthrough breaks my data by adding filters

[fuqmicrosoft]

Hi, 

I'm trying to just have a spreadsheet that links to another page, but it keeps adding a filter and my data breaks.  

This is the table being drilled down from:

And here's the page it links to:

I didn't put that highlighted filter on there.  Everytime I drill down, I get this stupid filter added without my permission and it breaks the report.  How do I stop it?

Thanks,

Fuq.

PS.
Here's what it looks like before I drillthrough:

[v-yuta-msft]

@fuqmicrosoft ,

The drillthrough filter will filter the page based on the selected value. I would suggest you refer to tutorial below:

https://www.sqlbi.com/articles/introducing-the-power-bi-performance-analyzer/

Community Support Team _ Jimmy Tao

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

[fuqmicrosoft]

Also, your link was to a perfomance analyzer?

[fuqmicrosoft]

Is there no way to link from one page to another in a drillthrough manner without filtering?  I just want to essentially hyperlink from dynamic values in a matrix to a sheet.

[v-yuta-msft · Accepted solution]

@fuqmicrosoft ,

Drillthough will always filter the data. In your senario, you can clear the filters in "keep filters" section after drillthrough. Another workaround is that you can create a button and configure action which direct to a bookmark.

About how to create button and link to bookmark, you can refer to doc below:

https://docs.microsoft.com/en-us/power-bi/desktop-buttons#select-the-action-for-a-button

Community Support Team _ Jimmy Tao

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