Where do i start with a tag search function?

[Elohelae]

Good morning, Im not expecting coding help, more of a strategy to start from.

I have documents that have tags based on their content. I want to enter a combination of tags and then a list of documents that match those tags the closest, then list further documents in order of % match. Im not sure what the best way is to achieve this. Im thinking of creating a table with the documents and separate columns for each tag, then filter, however, I'm not sure how effective that would be in matching. I'm looking for guidance on a strategy to approach this, any thoughts?

Lola

[v-stephen-msft]

Hi @Elohelae ,

It is recommended that you create a matching table to match the primary table in Power Query.

Here's the reference.

Power Query - Matching a value from a list using power Query - Microsoft Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Elohelae]

@v-stephen-msft 

Thank you for the response. In the solution you provided, what i am looking for is that the table is already populated, but then I would want to look for the best match based on keywords. For example. I might need to seach for "Bahrain", "Mob" and "Viva".. I want it to return the 1 record in the table with all 3 with 100% match, but then indicate a match to just Bahrain and Mob, with a 66% match and Mob or Bahrain with a 33% match etc or austria and mob being a 33% match based on Mob etc.  Ive thought about 3 columns, The document, the tag and then the number 1 if that tag is relevant to the document. Then filter the tag row based on the tags i want to search for and then do a count in the number row, and order from the highest count to lowest. What are your thoughts on that?

Lola

[lbendlin]

What made you decide to use Power BI for this?

[Elohelae]

@lbendlin 

It is part of a dashboard which will display the status of issues. The issues are keywords which I want to use to search tagged documents, which are then presented to the user as possible solutions. There are 13 tags which appear in various combinations in our document library, and I want the most relevant displayed to the user. I want the problem and the solutions displayed as the report.

[lbendlin]

Power BI is really bad at using "OR"  filters. it is designed to superimpose filters ("AND") 

You may be able to get a custom visual to do what you need but it will have rather poor performance.