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
wadda7
Helper I
Helper I

How to make one of the filters to filter only one table in the page

Hello Everyone 

I have this 3 filters and 2 tables  in my report  , I want when the user use the filter no 3 the table 2 only filterd and when the user use any other filters in the page it can filter both table 1 and 2 

 

powerbi filter.jpg

 

 

 

 

table1      
       
       

 

tabel2      
       

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

If you select your 3rd slicer then go to format > and turn on 'Edit Interactions" you can stop that slicer from filtering the first table.

jdbuchanan71_0-1660851762984.png

 

View solution in original post

4 REPLIES 4
jdbuchanan71
Super User
Super User

If you select your 3rd slicer then go to format > and turn on 'Edit Interactions" you can stop that slicer from filtering the first table.

jdbuchanan71_0-1660851762984.png

 

 Thank you  jdbuchanan71 

Thanks JD,

In my haste, I believe I had it backwards....

rsbin
Super User
Super User

@wadda7,

You want to use the Format -> Edit Interactions button on the Toolbar.

Select your Tabel2, then select the Format menu. Select Edit Interactions.

rsbin_0-1660851492804.png

Once you do this, then you can disable the interaction with Slicer 1 and Slicer 2.

Regards,

 

 

rsbin_2-1660851628232.png

 

 

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.