Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Filter opportunities that feature 2 products selected from slicer

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. 

1 ACCEPTED SOLUTION

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

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.

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

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. 

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

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.