Before someone tells me that I can select two values in a slicer and that does the trick. I know that but that is not what i want here.
The idea is to have 1 v 1 comparison. So I need two slicer on the same column where the user can select 1 product from the first slicer and another product from the second slicer.
The problem which I am facing is that any graph created tries to filter both products and results in blank as Slicer 1 AND Slicer 2 is Null (which is obvious). I am thinking something like Slicer 1 OR Slicer 2 might do the trick but am open to any ideas you have.
I have created two slicers on LHS DateRange and RHS DateRange tables. No matter if I select a single date or a range of dates or multiple dates from the date slicers, I don't get any values in the CustomLHS or CustomRHS measures.