Forum Discussion

BenjaminFernet's avatar
BenjaminFernet
Regular Visitor
2 years ago
Solved

Exact match text filter

Hello!   I have a Power BI report that contains 2 tables. The first, Customers, is a list of customer numbers (unique) and their account number. The second, Accounts, is a list of account numbers (...
  • BenjaminFernet's avatar
    2 years ago

    What I ended up doing is change the source code of the Text Filter made by Microsoft. Somewhere in there, you can change the operator from "Contains" to "Is" and recompile the visual.

  • BenjaminFernet's avatar
    BenjaminFernet
    1 year ago

    Sure!

     

    First I downloaded the widget's source code from their repo here.

     

    Then I installed pbiviz by following this tutorial.

     

    Finally, I modified the source code. Here is a summary of the changes I made :

     

    • in src/visuals.ts I changed the performSearch function to use the operator "Is" instead of "Contains"
    • in pbiviz.json, I changed the name, display name and version

    I then recompiled it using the pbiviz doc. It's been working quite well.