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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.