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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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