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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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