Power BI

Needs Votes

Multiple Value - Custom List Filter

Vote (192)

Mark S Yassay on 25 Jan 2017 01:29:16

A report filter with the ability to copy a list of data, be it numerical or text, from an excel document and paste it into a filter allowing for the visualization to update.

This would be similar to a Multiple Values - Custom List filter in a competitors visualization software.

Real world example: If you have a data set that is made up of 100,000 SKUs and you want to analyze a list of 100 SKUs with different attributes, but the only thing you are interested is this custom list.

If this is already an Idea I am happy to vote that up and remove this post.

Thanks for your help.

Comments (18)

Comments (18)

1ac5708c d6c0-4bbb-a9d9-6366e4e96613 on 05 Jul 2020 23:37:44

RE: Multiple Value - Custom List Filter

Currently we are having to export to Excel to do a V-Lookup. This needs to be solved.

bae5e95f 7945-4b75-9fc4-c3df83684223 on 05 Jul 2020 23:36:31

RE: Multiple Value - Custom List Filter

This is the main improvement that I want for Power BI

c1430344 5986-414d-a573-e872bd2bacf1 on 05 Jul 2020 23:30:46

RE: Multiple Value - Custom List Filter

this is 100% needed i come up against this issue constantly.

f92edb87 331f-4fdf-9e4a-6952445b8f9c on 05 Jul 2020 23:29:23

RE: Multiple Value - Custom List Filter

Agree! Under "Advanced Filtering", possibly add "Is in the list" and "Is not in the list" options where we can paste a long list of values.

265d50dc 3703-4a8a-8943-71c4bcd997ed on 05 Jul 2020 23:25:20

RE: Multiple Value - Custom List Filter

Hi, this requirement is basic and must.
As of now visual level filter allow up to 2 values only. We should have minimum 100K

Thanks

0a2b8164 5120-4b6f-93d2-bc9bb613a84a on 05 Jul 2020 23:12:53

RE: Multiple Value - Custom List Filter

Thank you. It's a great feature were in users were able to paste 200 materials in one go but found few things might make it more useful. For example, users might want to check SKU's starting with 3* or 3% or just typing in first 4 numbers of the SKU.

a9d3885a b51d-4451-921b-f11b78928075 on 05 Jul 2020 23:06:27

RE: Multiple Value - Custom List Filter

This is a big need for users of Power BI Reports!

4bd13aff eb95-49d5-8772-e15b67830ac8 on 05 Jul 2020 22:54:28

RE: Multiple Value - Custom List Filter

I use custom filters using a prompt box with copy/paste lists of values from Excel using Business Objects every day and I need this same ability in Power BI now! I have the same issues with many thousands of product SKUs and will soon will be working with over 10,000+ store locations.