Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Search Box

I need to create a search bar on power bi. The user inputs ID, which filters a table viz I have created. The search bar must not have a drop down feature.  The result should only display table val...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    You might try the what-if parameter.
    Here is my sample data:

    I create a What-if parameter here:

    Close here and the slicer will only have a search bar:

    Then use the DAX below to create a new measure in the data table:

    SelectedData = 
    IF(
        SELECTEDVALUE('Table'[ID], 0) = 'Parameter'[Parameter Value],
        1,
        0
    )

    Apply 'Filters on this visual' as shown below:

    The final result is shown below:
    Without input:

    Input 1:

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Search Box.pbix28 KB