Forum Discussion

mumair's avatar
mumair
Icon for Helper I rankHelper I
9 years ago

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 in...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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