cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Patron
Post Patron

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
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Solution Sage
Solution Sage

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  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 @bchager6 ,

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 Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors