Forum Discussion
Fuzzy matching threshold slider
hi, i am using fuzzy matching in power bi for my report.
is it possible to have a slider in my dashboard (report view) where users can adjust the threshold value for the fuzzy matching?
Hi kellyylx ,
In power query, Cluster values uses a fuzzy matching algorithm to automatically create groups with similar values, and then maps the values in each column to the best matching group. This transformation is useful when you are working with data that has many different variants of the same value and you need to merge the values into consistent groups.
In the Show similarity scores option of Fuzzy cluster options, you can adjust the similarity threshold.
More details can be found in the documentation:
How fuzzy matching works in Power Query - Power Query | Microsoft Learn
Cluster values - Power Query | Microsoft LearnIf your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi kellyylx ,
In power query, Cluster values uses a fuzzy matching algorithm to automatically create groups with similar values, and then maps the values in each column to the best matching group. This transformation is useful when you are working with data that has many different variants of the same value and you need to merge the values into consistent groups.
In the Show similarity scores option of Fuzzy cluster options, you can adjust the similarity threshold.
More details can be found in the documentation:
How fuzzy matching works in Power Query - Power Query | Microsoft Learn
Cluster values - Power Query | Microsoft LearnIf your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.