Using Text Filter for exact match

[lkshck]

Hey, 

I'm currently using the Text filter from Microsoft to filter on the visuals. Unfortunately the Text filter uses the contains operation instead of equal. Is there any way to switch to equal instead of contains? Or maybe an option that the user can select which operation should be used in the Report? Something like this:

[truptis]

@lkshck , We can also use custom visuals for text filtering -

• Text Filter by Microsoft
• Smart Filter by OkViz

Hope this helps you!

[lkshck]

Solution with the search works for now, but isn't the best from my point of view. Currently used the Text Filter by Microsoft but this one uses the contains operation instead of equal. 

Thanks for the help.

[truptis]

Hi @lkshck, 
Option 1:

In a slicer, you can have this search option for exact match(Screenshot):

@lkshck -> if this helps you, then please mark this as a solution. Thanks.

[Greg_Deckler]

@lkshck Well, you could create your own measure for filtering. I call them Complex Selectors:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633?search-acti...

Basically in your case maybe a slicer with the words and then something like:

Selector Measure = 
  VAR __Value = SELECTEDVALUE('Slicer'[Value])
RETURN
  IF(MAX('Table'[Column]) = __Value, 1, 0)

[rocketship]

Trying to use your dax to build my expression.  I'm using the Microsoft Text Filter visual to find an exact match for a birth date.  There is a table visual in the report which will show the employee and birth exact match. If no exact match, no employees should show. 

All birthdays in the dataset are text fields formatted as 6 characters, 010176.

 I'm not sure how to apply the selected value to the search box.  Do I filter for 1? Or 0? On the search box or the visual table in the report?  Any help would be great. 

Selector Measure =
VAR __Value = SELECTEDVALUE(TABLE[BBD)
RETURN
IF(LEN(__Value) = 6 && MAX(TABLE[BBD) = __Value, 1, 0)

[amitchandak · Accepted solution]

@lkshck , When you use search in Normal slicer, that it force selection of exact value (Option under three dots)