Forum Discussion
Filter on Multiple Fields
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
3 Replies
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
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.
Hi Anonymous,
For your scenario, you could try with the feature Edit interactions for the two slicers.
Best Regards,
Cherry
