Forum Discussion
Julian_H
3 years agoHelper II
Slicers and OR statement
Hi, I have had a request to set up a report in PBI that would require a slicer that always "OR". For example , I have a data set that has Name 1 and Name 2 in it. I want th user to be able to...
- 3 years ago
hi Julian_H
check this blog
https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/
Julian_H
3 years agoHelper II
Sorry the data is sensitive but here's a mock up
| Account | Name 1 | Name 2 |
| 123 | John | Peter |
| 456 | Mary | David |
| 789 | Peter | Paul |
So from the slicer(s) the user for example wants all data where Name 1 = John and Name 2 = Paul
So in this instance you would get a list showing account no's 123 and 789
FreemanZ
3 years agoSuper User
hi Julian_H
check this blog
https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/