I have built a Search box using parameters and Contains function. But my client need the drop down with only matching list .
Even tried adding all values to parameter list and customizing the parameter in dashboard.
However, drop down will have all the values instead of only matching values.
Can anyone help in building the Search Box with matching values in the drop down menu
Please Mock up some workbook for someone to have a look to help you.