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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
maryamab
Frequent Visitor

Search box in page level for buttons

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

4 REPLIES 4
Anonymous
Not applicable

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

vheqmsft_0-1716516314154.png

Get more visual and choose Text search slicer

vheqmsft_1-1716516373771.png
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

vheqmsft_2-1716516524857.png

Final output

vheqmsft_3-1716516558426.png

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 

Anonymous
Not applicable

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

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors