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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
dadomel
Regular Visitor

search text in real time in power bi

Hello

Is it possible to make a text search engine that searches as you type ?

i.e. if I type CZC
that the words that begin with CZC appear and not the rest, but in real time as I type and the C is erased, it shows me the words that contain CZ at the beginning.

thanks in advanced

 

1 ACCEPTED SOLUTION

You have to give focus to the visual. No way around that.

View solution in original post

5 REPLIES 5
v-jtian-msft
Community Support
Community Support

Hi, lbendlin and danextian ,thanks for your concern about this issue.

Your answers are excellent!
And I would like to share some additional solutions below.
Hello,@dadomel .I am glad to help you.
1. Searching with a slicer is a very common way to find.
This function can be used when the field type of the slicer is Text.

vjtianmsft_0-1732860226172.png

You cannot use the search function when the field type is a numeric type

vjtianmsft_1-1732860257352.png


2. You can use custom visual objects to implement your text field search function.
Text filter visual

vjtianmsft_2-1732860296457.png

vjtianmsft_3-1732860320336.png

 

vjtianmsft_4-1732860331304.png

 

vjtianmsft_5-1732860342521.png

Note that it can search for text type data (fuzzy query support), but not numeric type field data.
When I use [Total] as a numeric search field, it doesn't work.

vjtianmsft_6-1732860977371.png

You can get more customised visuals with search functionality in Power BI visuals.

vjtianmsft_7-1732861029519.png

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hi @v-jtian-msft .

 

I try to explain it with pictures, in case there is a solution

dadomel_0-1732877234792.png

initial state 

 

dadomel_1-1732877269834.png

I write but I do not find the content of the SN column until I click on the magnifying glass

dadomel_2-1732877341152.png

when I have given the magnifying glass it does it, but I want it to do it while I am writing and not only when I give the magnifying glass.

 

is possible? 

 

You have to give focus to the visual. No way around that.

danextian
Super User
Super User

You should be able to do that using the search feature of the old slicer. You'll need to select from the filtered results though.

danextian_0-1732836419246.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
lbendlin
Super User
Super User

You seem to be describing the standard functionality of the filter pane?

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.