Forum Discussion
multiple item search slicer (I need help with finding a certain visualization)
Hey there!
I have a quick question about visualizations.
I know that you can download visualizations from the store.
I was wondering if anyone knew of a slicer that would allow me to enter in multiple items to search. I have one that will allow me to search for one single item (see photo) but I need to be able to search for multiple items. I need to be able to copy like 1000 line items from excel and paste it into power BI and have the dashboard give me data on all the items entered.
Does that make sense?
If not, please let me know so that I can clarify :smileyvery-happy:
Thanks in advance!
I believe this was an added feature in the February update. See link below:
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2018-feature-summary/
10 Replies
- drewlewis15
Solution Specialist
I believe this was an added feature in the February update. See link below:
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2018-feature-summary/
- AnonymousNot applicable
Hi,
I don't find the solution in the 2018 Feb feature summary, and could you please show me how to search multi values in the slicer?
Thanks.
Aiolos Zhao
- STANLEYZHANGFrequent Visitor
I also encountered the same problem. Have you solved your problem? Can you share how you solved it? Thank you.
- rajulshah
Resident Rockstar
- baBI123
Helper II
Hi rajulshah! Thank you for your reply.
I already have Smart Filter but when I copy and paste large amounts of data, it does not give me what I need.
Let me try to explain with an example...
I have an excel list full of serial numbers for car parts and I want to be able to copy the whole field (or column- same thing :manhappy:) with about 500-1000 serial numbers and paste it into a search box on my POWER BI report that will, in turn, give me information for just those particular part numbers.
I have attached a screenshot to show you the problem that I am running into ...I hope that this makes sense! :smileyvery-happy: please let me know what you think!
- AnonymousNot applicable
baBI123,
I don't think that the existing custom visuals or built-in slicer provide the feature you describe, I would recommend you submit a feature request in the Power BI ideas.
https://ideas.powerbi.com/forums/265200
Regards,
Lydia
- STANLEYZHANGFrequent Visitor
not free😀
- ambi95
Helper I
I have the same requirement, by any chance, is there a concrete solution for this? alexabell baBI123 drewlewis15