Forum Discussion
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 can use either visual, whichever works the best. The solution should be based on data query I can use. I'm using a Text column in the search bar and a table that gets filtered based on the user's input. Here is how I want it to behave: user types “data” and only rows where TERM = "data" are shown. Thank you in advance
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
7 Replies
vicky_Super User
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".
- nielsvdc
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.
Hi rkhidesh,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to nielsvdc and vicky_ for prompt and helpful responses.
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna KumarHi rkhidesh,
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna KumarHello, sorry, no they did not help solve my issue and I haven't found a solution yet either.
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
Hi rkhidesh,
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar
