Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello
is there any way to create search box where the user input and the buttons in the page sorted to showe the first button is what the user searched for ?
Thank you
Hi @maryamab ,
As per your description, in power bi we are not able to sort button or table data based on the text entered. But we can create a measure and then sort the measure in the visual object. Here are my steps for implementation:
Sample data
Get more visual and choose Text search slicer
Create a new table
Table 2 = VALUES('Table'[Name])
Create a measure
Measure =
IF(
SELECTEDVALUE('Table 2'[Name]) = SELECTEDVALUE('Table'[Name]),
1,
0
)
Use Table2[Nmae] as value of the slicer
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you for your help
What do you mean by visual objects ?
and where can i use the measure ?
I will create a table with groups of objects names
and i will use it to sort ..
Note :
i have almost 20 groups ( each one contains button and text )
i will create the table for groups name and use your approach
Hi @maryamab ,
Thanks for your reply, I didn't explain it clearly. In power bi, the visual object refers to the charts and such that you see on the report page. Just like the table I created above. We are not able to sort the buttons by filtering, but we can sort the table based on what is selected. You can put the measure into the form visualization and then sort it by the size of the measure.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!