Select row by typing

In Power BI, you can achieve the functionality you're looking for by using the "Filter" option in the matrix visual. Here's a step-by-step guide:

1. Matrix Visual:

   • Add a matrix visual to your report.
   • Place the field you want to filter by in the "Rows" or "Columns" well.

2. Filtering:

   • Click on the dropdown arrow in the column header of the field you want to filter.
   • Choose "Text Filters" and then select "Contains."
   • Enter the first few letters of the text you want to filter.

3. Search Box:

   • If you want a dedicated search box, you can add a slicer visual.
   • Create a slicer using the same field, and users can type in the slicer to filter the matrix.

4. Keyboard Shortcuts:

   • In Power BI Desktop, users can use keyboard shortcuts to navigate and filter the visuals.
   • For example, pressing Ctrl + F opens a search box that allows users to search for and select values.

5. Custom Visuals:

   • If the built-in features do not fully meet your requirements, you can explore custom visuals available in the Power BI marketplace. There might be a custom visual that provides the exact functionality you're looking for.

6. Power Query:

   • If your data is loaded into Power Query and you want to filter the data at the source level, you can apply filters in Power Query.
   • Use the "Filter Rows" option in Power Query to filter rows based on specific criteria.
     
     
     Best Regards
     Saud Ansari
     If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!