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 (44)
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
RE: Multiple Value - Custom List Filter
Selecting multiple values with the current slicer is fine until you are on your 10th selection. My organization has a high demand to paste multiple values to filter the data model that I had to develop my own data model outside of PowerBi to achieve this.
RE: Multiple Value - Custom List Filter
We have daily tasks that require us to filter specific groups of document numbers. Having the ability to paste lists or something like pipe-delimited or semicolon-delimited values would help tremendously. Please Micosoft, it can't be that hard.
RE: Multiple Value - Custom List Filter
We need this feature as it's taking almost taking more than 3 hours create a report with single value filter. This would be really helpful if you could get this in AppSource soon.
RE: Multiple Value - Custom List Filter
Seriously, can we not get this?
RE: Multiple Value - Custom List Filter
Please consider to add this feature as it is very usefull for Financial reports where the analyst needs to update big lists of SKUs
RE: Multiple Value - Custom List Filter
Agree with previous comments!
it's very important function for user's adhoc analysis