Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

OR condition on multiple slicer selections

I have a streaming dataset dashboard that 6 slicers currently available for a table of data. The 6 slicers each represent a different column in the table but I need them to act as OR's and not AND's...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    I made a simple document to illustrate it.

    1.The first step is to have 6 tables independent of each other, without any relationship (my file here is using two slicers, so two tables)

    2.Then create a measure.

    flag = IF(MAX('Table'[column1]) in ALLSELECTED(slicer1[column1])||MAX('Table'[column2]) in ALLSELECTED(slicer2[column2]),1,0)

    3.apply the flag measure into filter.

    The final output is shown below:

    If you also not clear, can you share me the simplr file after removing the sensitive information?

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

I made a simple document to illustrate it.

1.The first step is to have 6 tables independent of each other, without any relationship (my file here is using two slicers, so two tables)

2.Then create a measure.

flag = IF(MAX('Table'[column1]) in ALLSELECTED(slicer1[column1])||MAX('Table'[column2]) in ALLSELECTED(slicer2[column2]),1,0)

3.apply the flag measure into filter.

The final output is shown below:

If you also not clear, can you share me the simplr file after removing the sensitive information?

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aallman's avatar
aallman
Helper II
3 years ago

I have the same problem where I want to have 3 slicers act as OR filters on my visual. I tried to use your solution but it doesn't quite work. If you select no filter in one of my 3 slicers, then the data doesn't get filtered at all. It seems to be the same case with your example data:

 

how can I get this to work so that no selection in one of the slicers will cause the data to filter only by actual selections?