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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
cristianj
Helper IV
Helper IV

display rows not containing selected lines from slicer

Hello , i have a table which contains a row in which i have the combinations from slicers rows, i want to display only record which not contain any of the slicers values, so this is my table

idstring
id1string1,string3
id2string4,string1
id3string2,string5
id4string2,string3
id5string6

 

this is my slicer

string1
string2
string3
string4
string5
string6

 

i select string1 and string3, and i want to display

 

id3string2,string5
id5string6

any sugestrions would be great , thank you

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RizS8gb7h7VBBSEMq?e=AlGsb1

View solution in original post

2 REPLIES 2
Ahmedx
Super User
Super User

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RizS8gb7h7VBBSEMq?e=AlGsb1

Hello and thank you for answer, my situation is a little more complicated, 

you create a table with the result, the problem is that i want to be a filter, because the first table, the one that i want to filter, has 40 columns and more than 800 000 rows and counting . Thank you

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.