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
v-esde
Frequent Visitor

one slicer filter restriction from other slicer selection

Hello All,

 

I have 2 slicers one slicer is having DC and second slicer is having locations.If I select DC, related locations are displayed on second slicer, it is fine. When I select location on second slicer, showing all the related DCs on first slicer, it shouldn't happen. how to restrict it not filter the first slicer when I select second slicer value(DC). 

 

Thanks in advance.

5 ACCEPTED SOLUTIONS

v-haibl-msft
Employee
Employee

@v-esde

 

@pxg08680's solution should be correct. You can also take a look at this document for reference.

 

Best Regards,
Herbert

View solution in original post

@v-esde

 

Please refer to following gif for the steps.

 

one slicer filter restriction from other slicer selection.gif

 

Best Regards,
Herbert

View solution in original post

Thanks a lot herbert. My issue is resolved.

View solution in original post

@v-esde

 

You can mark the right answer as solution, so that other users who have the same problem can find the correct solution quickly.

 

Best Regards,
Herbert

View solution in original post

8 REPLIES 8
v-haibl-msft
Employee
Employee

@v-esde

 

@pxg08680's solution should be correct. You can also take a look at this document for reference.

 

Best Regards,
Herbert

I couldn't see any option(s) on edit interactions, not able to edit it. Could you please tell me exactly which actions/steps should I follow.

@v-esde

 

Please refer to following gif for the steps.

 

one slicer filter restriction from other slicer selection.gif

 

Best Regards,
Herbert

Thanks a lot herbert. My issue is resolved.

@v-esde

 

You can mark the right answer as solution, so that other users who have the same problem can find the correct solution quickly.

 

Best Regards,
Herbert

pxg08680
Resolver III
Resolver III

@v-esde

Out of my understanding you have two slicers but you don't want the second slicer to filter the first.

Select the second slicer and in Format section on top select Interactions. Play out with these selection , it has fliter, don't filter.

Thanks for your reply.

 

I couln't see any option on interactions.

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.