Forum Discussion

rkhidesh's avatar
rkhidesh
Frequent Visitor
9 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

nielsvdc's avatar
nielsvdc
Icon for Super User rankSuper User
9 months ago

Hi rkhidesh, why would you limit users to a single, strict search term and prevent them from refining their search by adding more text? Imposing such restrictions can lead to a frustrating user experience. Let us know and maybe we can help you more.

 

Hope this helps. If so, please give kudos 👍 and mark as Accepted Solution ✔️ to help others.