Forum Discussion
Drillthrough breaks my data by adding filters
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:
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.
4 Replies
v-yuta-msftCommunity Support
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.
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
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.
Also, your link was to a perfomance analyzer?
