Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
That is how filters and slicers work. However, I'd still like to help. Please share some data and show the expected result.
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.
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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
93 | |
60 | |
43 | |
35 | |
34 |