Forum Discussion

maryamab's avatar
maryamab
Frequent Visitor
2 years ago

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

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

     



     

    • maryamab's avatar
      maryamab
      Frequent Visitor
      2 years ago

      Thank you for your help

      What do you mean by visual objects ? 
      and where can i use the measure ?

      • maryamab's avatar
        maryamab
        Frequent Visitor
        2 years ago

        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