CODEWITHSUNDEEP
powerbipowerbi-desktop
fdkgfosfskjdlsjdlkfsf
fdkgfosfskjdlsjdlkfsf

Reputation: 3301

Powerbi Desktop: How to filter without having to select each item?

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.

enter image description here

Upvotes: 0

Views: 79

Answers (1)

Gangula
Gangula

Reputation: 7332

This is possible by using the "Filter by List" custom visual from Pragmatic Works.

Check-out their demo video in the above link - which is the following video

Upvotes: 0

Related Questions