cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to Limit Slicer Choices

I'm using multiple slicers when I'm generating a report, and I just ran into this issue. I want to compare two different locations, so I go to the location slicer and choose the two locations I am interested in. I then want to compare how they perform based on shared products, so I go to the product slicer. However, all the products that are manufactured at either location are allowed to be chosen in this slicer. I was wondering if it would be possible for the slicer to only show products that are maunfactured at both facilities.

5 REPLIES 5
Highlighted
Microsoft
Microsoft

Re: How to Limit Slicer Choices

@mumair,

 

In Power BI report, the logic operation between items in a slicer is OR. In your scenario, you need the AND operation between two locations in your silcer. Based on my research, there is no such a option that allow us to change it.

 

Thank you for your understanding.

 

Regards,

Charlie Liao

Highlighted
Frequent Visitor

Re: How to Limit Slicer Choices

Use a slicer to limit the choices of another slicer, then hide the first slicer.

It may be silly, but do work.

Highlighted
Frequent Visitor

Re: How to Limit Slicer Choices

The problem is.... that one slicer wont limit the choices of another slicer. Thats the problem that needed to be solved?

Highlighted
Frequent Visitor

Re: How to Limit Slicer Choices

The problem though is.... one slicer will not limit the selection of another slicer. Thats the fundamental problem that needs solving. Hiding it wont fix the fact that the remaining slicer still shows all the selection.

Highlighted
Resolver I
Resolver I

Re: How to Limit Slicer Choices

You can Sync the slicers and thus one slicer selection can impact another.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors