Forum Discussion
Find common values based on selected category
fz1 I think this video on my YT channel will get you going How to override slicer selection to return all records | PeryTUS - Power BI How To - YouTube
- fz13 years agoFrequent Visitor
thank you so much for the response, but I believe what I'm trying to do is a little different than what the video is showing as my data is structured differently. The video shows the first two records have the same combination of "Work Order" and "Responsible" (1234567 and Dan) - my dataset is different in that each combination of "Work Order" and "Responsible" is unique. So, to go back to my requirement: I am trying to find what Items are common in the Stores; to give another example, if I select stores B and C, it will show only the common items in both stores (=bread and cheese).
To give a little more context, all my data is currently in one table (so I wouldn't need to link any tables) and I am using one of the columns as a slicer (in the above example, it is the Store column). Also, the real dataset I am using has about 10k records.
In summary, I am trying to make multiple selections on the slicer and have it return the intersecting records on my table based on the slicer as opposed to returning all the records (which is what it is currently doing).