Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello all...
I have a general question on filter behavior; specifically when fields are brought in to the drill through well as opposed to the page level filter pane.
Has anyone seen the filters behave differently depending on where they're located?
For example; if I have an active project yes/no filter and a project ID filter, both in the drill through well, selecting active project yes while that filter is in the drill through well will filter different project IDs than if I have the active project yes/no filter in the page level filter pane.
Interested in hearing your thoughts
@Anonymous - So, yes from a DAX perspective. For example, if you put a filter in a page level filter, even ALL will not bring back the data that was filtered out by the page level filter.
@Greg_Deckler Thanks for your response. I understand how that works. With the scenerio I'm talking about though; if I have only 2 filters in the page, an active project yes/no and project ID filter, and they're both in the drill through well, if I select active project yes, a different set of projects will return in the project ID filter dropdown than if I move the active project yes/no filter to the page level filter pane. It's really strange, and this is before I even try to drill through from one page to the page I'm referring to.
Hi @Anonymous ,
Maybe you can try to understand it under this way:
Although filters on this page and drill through filter are both page-level filters, the priority of filters on this page is higher than drill through filter. When you set filters on this page on the target page in advance, when using drillthrough, the drillthrough filter will retrieve whether the target page has a qualified value, such as the yes/no filter you mentioned, if you set yes in filters on this page, when you drillthrough a no value, since the target page only has the value of yes, the target page will return a blank value; if you set a drillthrough filter such as yes on the target page in advance, this will only display the value of yes on the current target page, and the corresponding filters on this page will also change only yes, and when you drillthrough a no value, the target page will automatically become your drillthrough no value instead of yes.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |