@MVB,
Welcome to the forum - great to have you here!
If you’re willing to use custom visuals, there’s a really simple and direct solution to this problem. OKViz (the SQLBI guys) has a custom slicer visual (SmartFilter Pro) that has and/or filtering logic built in. I use it in many of my reports, because it expands the standard slicer capabilities in a number of valuable ways. I’ve posted pretty extensively about it here.
If you’re not willing/able to use custom visuals, this article should be helpful to you:
I hope this is helpful.
- Brian