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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.