Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
Anonymous
Not applicable

General Question on Filter Behavior

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

4 REPLIES 4
Anonymous
Not applicable

Page-level filters do indeed behave in a way some might view as... strange. But they are not strange. They do exactly what they should. A page-level filter filters everything on the page in such a way that no other data can be brought into the light. So, even ALL( T[Column] ) DOES respect the filter.
Greg_Deckler
Super User
Super User

@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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@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.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.