Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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.

Anonymous
Not applicable

@Anonymous 

 

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

What made you decide to use Power BI for this?

Anonymous
Not applicable

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

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.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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