When selecting multiple choices in a slicer, the table shows results that are either one, not both.

[krnahabedian]

I have a geo region column that is comma delimeted in my main table. I did a row split in a new table and linked on ID. I used a slicer visual with the new geo data to filter the table visual. The slicer shows each option without commas. The table shows the original geo column info with commas. Great. That's how it needs to look. When 1 option is selected, the rows with that option within the comma list shows up. Great. When 2 options are selected, it acts as an "or" statement and shows rows with either one or the other options within. I need the slicer to act as an "and" filter. How can I do that?

[v-xicai]

Hi @krnahabedian ,

You may change the Cross filter direction of relationship between the main table and the new table from Single to Both , which will take these tables treated as a single table. Then when you make some changes in someone table, the other table objects will return corresponding matched result.  See more:Create and manage relationships in Power BI Desktop .

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@krnahabedian did you look at this post, if this does not solve the issue, share sample data, and expected output.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[krnahabedian]

That's an interesting feature that will be useful on another part of my project, so thank you! I think my current problem is a bit different. Here's some more context.

I have my original table (OriginalData). Each company can have different numbers of geo regions covered. 

ID	Company	GeoCoverage
1	Company 1	USA,Australia,Asia
2	Company 2	USA,Asia
3	Company 3	Australia

I needed to split the geo coverages up to show only the distinct region options, not every combo as shown above. I made a new table (SplitGeo) and split GeoCoverage by rows. I linked it to OriginalData by ID 1:many and direction set to "both". 

ID	GeoCoverage
1	USA
1	Australia
1	Asia
2	USA
2	Asia
3	Australia

I have SplitGeo in a slicer and it shows 3 options: USA, Australia, and Asia. Great. I have the OriginalData table as a table visual as I need to show that original data for the user. Currently, when I select USA and Australia, all 3 companies pop up in the table visual. I need it to show only Company 1 as it is the only one to contain USA AND Australia. What can I use to be able to fiter this way? I hope this makes sense!