Forum Discussion

rkhidesh's avatar
rkhidesh
Frequent Visitor
8 months ago
Solved

Exact match using Microsoft's Text Filter or the Text Slicer

Hello, I want to modify either the Text Slicer or Microsoft's Text Filter so that instead of the "contains" logic, it uses "is" logic. I don't have admin priveleges so I can't install anything. I ca...
Need Help
  • Anonymous's avatar
    Anonymous
    8 months ago

    Hi rkhidesh,

     

    As suggested by nielsvdc  this feature currently isnt possible with the existing slicers in PowerBI.  You can try using a disconnected search table with a DAX measure to force exact match filtering instead of the default contains behavior. In this approach, the user types or selects a value in a separate slicer table, and a DAX measure then checks whether the value in the main table is exactly equal to that input. The table visual is filtered based on this measure. depending on the data model and user interaction, it may or may not perfectly fit every scenario.

     

    Thanks & Regards,

    Prasanna Kumar

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
8 months ago

Hi - 
that feature currently isnt possible with the existing slicers in PowerBI. 

one way to get a similar function is to use a regular slicer with TERM and then turn on search (click on the three dots and it should be the third option). they will have to click the exact term in the list of options.

 

Otherwise you can try use the "filters on this page" part of the filter panel. You would need to set it to advanced filtering, and then change "contains" to "is".