Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Where do i start with a tag search function?

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

5 REPLIES 5
v-stephen-msft
Community Support
Community Support

Syndicated - Outbound

Hi @Anonymous ,

 

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.

avatar user
Anonymous
Not applicable

Syndicated - Outbound

@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
Super User
Super User

Syndicated - Outbound

What made you decide to use Power BI for this?

avatar user
Anonymous
Not applicable

Syndicated - Outbound

@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.

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)