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

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.