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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
pallavikolhe
New Member

How to prevent this extra filter on this visual from appearing when matrix visual is used

I am using a Matrix Visual in Power BI and there is hierarchy added with 4 levels, and when I drill up or drill down by clicking on any value under the Sup Org field, an extra filter automatically appears in the Filters Pane (as shown in the screenshot). Also, just FYI when I'm clicking on '+' or '-' icon directly to drill up or drill down this issue is not coming.

I want to prevent this additional filter from being applied when performing drill actions. I have already tried:

  • Turning off "Keep all filters" in the Drill options.

  • Disabling the Drill up, Drill down, and Expand all down buttons in the Visual Header settings.

  • Checking and clearing filters manually from the Filters Pane.

Despite these efforts, the extra filter still appears. How can I stop Power BI from automatically adding this filter during drill operations?

 

Any help would be appreciated!

 

pallavikolhe_0-1741099545780.png

 

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @pallavikolhe,

Current it seems not support to accurately control these, maybe you can try to switch to use other filter(e.g. sync slicer) to pass these filter effect across report pages.

Enable the Sync Slicers feature in Power BI visuals - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
lbendlin
Super User
Super User

Don't use DrillDown?

 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

Helpful resources

Announcements