Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 months ago
Solved

Text BOX with multiple ids pasted and click submit button then in table gets values shown, pls help

Hi Team,

This is new concept to me, kindly help me as soon as possible.

In below visual I need to paste multiple tracking ids in text box or any other similar, later I need to click 'submit' button then results shown automatically for that particular tracking ids data in below table visual and some others filters are also dynamically filtered as corresponding to that particular data. 

and if you click 'clear' button then just shown blank it means with any tracking ids data. 

I tried with mass filter but it has different buttons like 'include matches, exclude matches, clear' but we required seperate button wise and simple, we need to paste multiple tracking ids and click on submit then results are populated.

Kindly help me as soon as possible.

Thanks

 

 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 months ago

    Hi Anonymous ,

     

    You can use a standard slicer on TrackingID with the search box enabled. This allows users to paste or type multiple IDs and select them in the slicer using multi-select behavior. This is a built in Power BI feature and works within normal filter context.

    To control the filtered view, you can use bookmarks to save the report state after selecting the required IDs. A button can be used to apply that bookmark state. For clearing the selection, another bookmark can be created with no filters applied, or you can use the built in reset to default option available in Power BI.

    This approach uses only native Power BI features such as slicers, bookmarks, and reset functionality, and does not require any custom visuals or external tools.

     

    Thank you.

9 Replies

  • Natarajan_M's avatar
    Natarajan_M
    Icon for Super User rankSuper User
    4 months ago

    Hi Anonymous , can you share the pbix along with the expected values so we can understand the requirement clearly?

    Are you looking for input slicer where you can type values ?


    Thanks





    • Anonymous's avatar
      Anonymous
      Not applicable
      4 months ago

      Hi Natarajan_M ,
      Thanks for your response, but unable to add the pbix file getting some error. I am not looking for input slicer.
      below mentioned with clear explanation.
      Snapshot 1 - Sample data,

      Snapshot 2 - Actually we are looking.

      Here I will paste multiple tracking ids (or) barcode values in Text box, after click submit button then only those filtered rows data will be shown in below table visual and beside filters.
      How I will achieve this, Kindly help me pls 
      Thanks