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

[Anonymous]

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!

[v-venuppu]

Hi @Anonymous ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @Anonymous ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Regards,

Rama U.

[Anonymous]

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!

[Anonymous]

HI @Anonymous,

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

[lbendlin]

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

[v-venuppu]

Hi @Anonymous ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,

Rama U.

[Anonymous]

Hi @Anonymous ,

To avoid filtering on individual fields, we recommend using the icons in the action bar. Enable the drill-down option by selecting the single downward arrow. Then, drill down or expand fields as needed. This approach helps maintain the desired data view without adding extra filters.

Related link: Drill mode in the Power BI service - Power BI | Microsoft Learn

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.