How can we improve Power BI?

Multiple Value - Custom List Filter

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.

94 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Mark S Yassay shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

14 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    I'm constantly making the case for Power BI over alternatives. Please Put this feature in!!! We need it - This would be a gut-punch to Tablleau snobs.

  • Rodrigo Lopez commented  ·   ·  Flag as inappropriate

    Please we need this to be added in PowerBi!!! I have been waiting a lot to have this for filtering a custom list for any field. Right now PowerBI only have the option to just make a selection of two or three values in the advanced filtering or selecting manually one by one in the basic filtering. This would help me A LOT in my work. For example, Tableau software already has it... but PowerBI should be better than Tableau!

  • Chris Johnson commented  ·   ·  Flag as inappropriate

    My company is migrating from Spotfire to Power BI and this is very easy to do in Spotfire. We frequently have to filter tables of 10,000+ values down to ~100 desired rows, and use Excel to produce a delimited string which is pasted into the filter. Current slicers only offer one-by-one ticking of boxes to achieve this which isn't practical.

  • Greg commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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

  • Abi Sivasubramanian commented  ·   ·  Flag as inappropriate

    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.

  • William Sowl commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.