Filter on Multiple Fields

[Anonymous]

I have a user requirement where they want to filter on multiple fields using "OR" 

e.g. Filter on Cost Price > 500 or Sales Price > 600. This should basically return rows with Cost price >500 OR Sales price > 600. When I use the filters on power BI desktop, it does an "AND" on the grid. Is there a way to create an OR filter on multiple fields without creating a new calculated column? Thanks

[v-piga-msft]

Hi @Anonymous,

For your scenario, you could try with the feature Edit interactions for the two slicers.

Best  Regards,

Cherry

[Greg_Deckler]

You might have better luck creating two disconnected slicers from your table and then creating a measure that returns yes or no if the criteria is met.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hey @Greg_Deckler 

Can you elaborate as to how I can do this? I think the users will be okay if there is another measure which will give them a Yes or a NO based on the criteria.