Forum Discussion

ctoscher's avatar
ctoscher
Icon for Helper I rankHelper I
5 years ago
Solved

Searching multiple columns for embedded report with close/fuzzy matches

We are looking to embed a report for our clients with a list of company names. They might know the companies by different names than us (we have a list of alternative names for each client) and they...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI ctoscher,

    In fact, current power bi filters not support advanced fuzzy match/search. Most custom filter effects required you to write the formula and apply it to the 'visual level filter'.

    From SQL to DAX: String Comparison - SQLBI

    Applying a measure filter in Power BI - SQLBI

    In my opinion, I'd like to suggest you use some advanced tools to process these fields to fix common string issues(typo, synonyms) before getting data to power bi. (e.g. machine learning, ai intelligence analysis)

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI ctoscher,

In fact, current power bi filters not support advanced fuzzy match/search. Most custom filter effects required you to write the formula and apply it to the 'visual level filter'.

From SQL to DAX: String Comparison - SQLBI

Applying a measure filter in Power BI - SQLBI

In my opinion, I'd like to suggest you use some advanced tools to process these fields to fix common string issues(typo, synonyms) before getting data to power bi. (e.g. machine learning, ai intelligence analysis)

Regards,
Xiaoxin Sheng