Filter opportunities that feature 2 products selected from slicer

[Anonymous]

Hi there,

In my dataset I have a few opportunities that features multiple products. I want to create a slicer that allows the user to select 2 or more products (multi-select) from the drop down and this will then return opportunities that at least feature the products selected with all else irrelevant. At the moment, when I select 2 products, the table is returned with opportunities that feature either one of the products selected which is not what I am looking for. 

Any help is appreciated, thanks. 

[Ashish_Mathur]

Hi,

That is how filters and slicers work.  However, I'd still like to help.  Please share some data and show the expected result.

[Anonymous]

Hi Ashish,

Thanks for offering to support.

Can you access the example from the link provided below?

https://drive.google.com/drive/folders/1w9o5DbR6_G1Xj9ioPDVthaqrK8kbJa3T?usp=sharing 

With both Apple & Grape selected in the top left product slicer, this should only show Opps 1 & 3 in the table further below.

Thanks.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Hi Ashish,

I've created the x3 measures but am unsure where to apply them as it wasn't too clear in the PBI file. Is it the case that I just apply the measure named 'Measure' onto my Table visual and that should do the trick? Do I need to set an conditions on the filter at all? 

Thansk. 

[Ashish_Mathur]

Drag the measure to the visual and apply the filter condition.  See the screenshot.