cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bienze
Frequent Visitor

How Do I Filter Multiple Values via copy/paste

Hi all,

 

I hope you can help me out.

 

In have scenario where my users would like to filter a column based on a copied list of values. For example a column from an excel file or a comma separated list. This would be handy when one wants to filter (for example) 200 numbers out of 100k records.

 

Manually checking values in a slicer is unworkable but I cannot figure out a better way with power bi desktop and service.

 

Any idea's to solve this?

 

Thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-jiascu-msft
Microsoft

Re: How Do I Filter Multiple Values via copy/paste

Hi @Bienze,

 

Please vote these two ideas: search-my-filter-values-in-a-dashboard and multiple-value-custom-list-filter.

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
Microsoft v-jiascu-msft
Microsoft

Re: How Do I Filter Multiple Values via copy/paste

Hi @Bienze,

 

1. Import the copied list of values. This step could be easy. Here the table is "FilterValues".

2.1 As a measure.

IfIn =
IF ( MIN ( 'Calender'[Date] ) IN VALUES ( 'FilterValues'[Dates] ), 1, 0 )

2.2 As a Calculated Column.

Column =
IF ( 'Calender'[Date] IN VALUES ( FilterValues[Dates] ), 1, 0 )

3. Create a visual and filter the result.

 

How Do I Filter Multiple Values via copypaste.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Bienze
Frequent Visitor

Re: How Do I Filter Multiple Values via copy/paste

Hi Dale,

 

Thanks for your reply!

 

I like your answer and maybe use it someday. In this case however, it doesn't solve the problem. The list of values cannot be imported because it could be any value of a(ny) column based on what the end user wants to filter. The report and definitions stay the same.

 

Example. The power bi report contains a list of customer analysis and details. A filter on Customer ID is added so the user can filter on a range or selected values. The user gets a request from a colleage with has a list of, lets say, 100 customer id's that need special attention. He/she wants to use this list and pastes it into the power bi report filter so the report filters down to these 100 customers. The next day, a different set of customer id's will be needed to filter. This can happen multiple times per day for multiple users.

 

Thanks

 

Highlighted
Microsoft v-jiascu-msft
Microsoft

Re: How Do I Filter Multiple Values via copy/paste

Hi @Bienze,

 

I have no idea about your actual model. So just some discussions here.

 

As you said in your first post, the column could be from a Excel file or a csv file. Import it, use it, finally delete the new table. Do these steps in the next searching.

 

There are still some other ways.

1. Paste the values in the Desktop directly. A new table will be created. You can delete it later.How Do I Filter Multiple Values via copypaste1.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2. If you can organize the values like this, you can paste it in the formula directly.  {"value1", "value2", "value3"}

IfIn =
IF ( MIN ( 'Calender'[Date] ) IN { "value1", "value2", "value3" }, 1, 0 )

 

Best Regards!

Dale

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Bienze
Frequent Visitor

Re: How Do I Filter Multiple Values via copy/paste

I like the Idea, but this function is not available in the power bi service. This would work for developers, but not for end users.

Microsoft v-jiascu-msft
Microsoft

Re: How Do I Filter Multiple Values via copy/paste

Hi @Bienze,

 

Please vote these two ideas: search-my-filter-values-in-a-dashboard and multiple-value-custom-list-filter.

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Bienze
Frequent Visitor

Re: How Do I Filter Multiple Values via copy/paste

Thanks, done!

Shelley Responsive Resident
Responsive Resident

Re: How Do I Filter Multiple Values via copy/paste

If you're still looking for this feature. I've found this custom visual slicer that provides this functionality. It does work. The limitation is that it cannot be synced across tabs, but it still comes in handy.

 

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381413?tab=Overview

 

If this addresses your need, please consider marking this as a solution. Thanks.

juchen
Frequent Visitor

Re: How Do I Filter Multiple Values via copy/paste

Hi @Shelley 

This exactly resolved what workaround I'm looking for, thank you so much!

Shelley Responsive Resident
Responsive Resident

Re: How Do I Filter Multiple Values via copy/paste

@juchen Great! Glad it helped you. Thanks for the feedback.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications