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 (40)
RE: Multiple Value - Custom List Filter
Any updates on when it would be fixed
RE: Multiple Value - Custom List Filter
I work for a large Consumer Packaged Goods company with thousands of Power BI users....we would all regularly use this feature. Please tell me it will be released soon!
RE: Multiple Value - Custom List Filter
Why has this not been developed? This should be basic functionality in the tool from the beginning.
RE: Multiple Value - Custom List Filter
Still waiting for such an option in the filters.. Just copy multiple values from an excel of other tool and past it...
RE: Multiple Value - Custom List Filter
I think this is still very much needed. Our organization doesn't want to rely on 3rd party solutions. This is also a privacy and security issue for many organizations.
RE: Multiple Value - Custom List Filter
I'm relying on the custom visual filter by 'DevScope' called 'Filter by List by DevScope'. I saved a copy of the file when they discontinued it, but luckily they added it back as well... I would rather not rely on 3rd party visuals for something so critical though. This should be a standard option - it would be nice to have in the filter pane or as a standalone visual similar to a slicer.
RE: Multiple Value - Custom List Filter
Tableau does this. Out of the box. Paste list into a filter should be basic functionality. Custom visual workaround 'Filter by List' by Devscope gets glitchy with Power BI updates. Not a goo alternative. Should be basic out-of-the box functionality. Come on Microsoft, you can do better.
RE: Multiple Value - Custom List Filter
Our large organisation needs the ability to copy/paste a list of part numbers to be reported on (e.g. 200 parts out of a potential 45,000, so totally impractical on a multi select list). Please can this be looked at and an option for a new slicer type to accept a pasted list of values be created? Thanks