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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MRUry7
Resolver II
Resolver II

unable to filter a field in a table from an unrelated table

Hi I have a slicer that contains keywords that I pulled out from a field in an unrelated table.  
I'm trying to filter that table, from the choice in the slicer. Since the slicer contains only a portion of the data in the record in that field, so I can't seem to create a way to filter a table where if the word from the slicer is found anywhere in the field in the record, i want to see that record .

When I check the word dogs, I want all records where the word dog appears in the pagename field.

MRUry7_1-1686058178215.png


Currently when I choose the word in the slicer, this is what it looks like. PageName field shows nothing:

MRUry7_2-1686058306012.png


So the bottom line is, how do i filter the table below the slicer, if a word picked off the slicer is found anywhere in the record?

Any help is appreciated. 
Thanks, Steve.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

use a measure to compute the match (1) or no match (0) for each row of the filter context. use that measure as a visual filter.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

View solution in original post

2 REPLIES 2
MRUry7
Resolver II
Resolver II

Thanks for your help on this challenge!

lbendlin
Super User
Super User

use a measure to compute the match (1) or no match (0) for each row of the filter context. use that measure as a visual filter.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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