cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Elohelae
Frequent Visitor

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

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.

@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

What made you decide to use Power BI for this?

@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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors