Filter using a list of items

[OptimusPrime]

I've been searching for a solution, but haven't found anything close.

As you can see from the screenshot, one of the fields in my Powerbi Desktop is DimCurrency.CurrencyName. In this example, there are 120 different currencies in DimCurrency.

Our end-users usually filter by different currencies, and it's extremely tedious and time-consuming to scroll through the list and check the 40 currencies that will be part of the filter.

Instead of selecting each one individually, is there a way to copy/paste the list into a filter box so that the items in the list are the filter? For example, our list may look something like this: "Euro,Forint,Lek,US Dollar,Won,Shilling"

Also, our endusers are non-technical, so this would need to be done in Powerbi Desktop (no MDX, external tables,  etc). Also, each filter is completely different, so we can't build "templates" that will be reused.

[v-luwang-msft · Accepted solution]

Hi @OptimusPrime ，

Use serach in Power BI

But use this  ,if you want to choose more items,you should choose one by one.

And you could use   the  visual on market place called "Filter By List".

Also you could try smart-filter .

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[PaulDBrown]

Doesn't the search function in the slicer help? I use it on a slicer with over 200 countries/territories for example

Also, if the currency selection is recurrent per user, they can add a personal bookmarks in the service once they have made the selection(s).

[mwegener]

Hi @OptimusPrime ,

Smart Filter Pro from OKVIZ seems to support something like this

https://okviz.com/smart-filter-pro/