Forum Discussion
Drilllthough sometimes does not pass filter
Anonymous,
I am not able to reproduce your issue. Could you please share the problem PBIX file to me so that I can test?
Regards,
Lydia
I can't really do that as it uses an on premesis tabular with very confidential data that I cannot send. It is so erratic that I don't know that I could reproduce, I just know that it comes up sometimes. I'll try to monitor it to see if I can find any more clues, and if I get the pattern I can try to put together a small sample.
Anonymous,
You can share us dummy data of your table via Excel file when you reproduce this issue.
Regards,
Lydia- tjd
Impactful Individual
Not sure I understand the problem. Drillthrough filters the page for only what you're drilling through on - country, product, actor, etc. That is the Drillthrough filter that's in the Drillthrough well. It does not pass along any other filters from the page on which you click drillthrough. On the other hand, bookmarks do allow you to set filters that persist when you go to the bookmark page. Sounds to me like you're getting drillthough and bookmarks confused or combining their respective capabilitites.
No, it is is a single drill through filter. In your example of country, I might drill through to England, France and Germany one at a time, but when I click on Spain up comes Italy. I go to desktop and discover that at the last publish Italy was in the drillthrough filter, So something is making occasional rows not pass the right data. I have double checked that the field on the rows is the exact field in the drillthough filter on the target page. It is very inconsistent and hard to reproduce, but I have seen it enough to know it is not my imagination.
I have been using bookmarks a lot, that's different, I am not confused.
Lydia,
I have been unable to produce with Excel, but am continuing to see the issue. With further testing, I now think it is unrelated to the filter state at publication. We continue to see this where the report is working in the service, but occasionally the drilltrough filter "sticks", drilling to a page bases on a row previously selected. Its happening pretty consistently. I would be happy to show someone via a webex if that can be arranged.
- Pete
Anonymous,
We will appreciate it if you can share PBIX file.
Regards,
Lydia
