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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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