Forum Discussion
How Do I Filter Multiple Values via copy/paste
Hi Anonymous,
Please vote these two ideas: search-my-filter-values-in-a-dashboard and multiple-value-custom-list-filter.
Best Regards!
Dale
Hi Anonymous,
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.
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
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.
Hi Anonymous,
Please vote these two ideas: search-my-filter-values-in-a-dashboard and multiple-value-custom-list-filter.
Best Regards!
Dale
Voted. Thanks for the links. Qlik has this. PowerBi should have had these features years ago!
Thanks, done!
If anyone hasn't found it yet, this custom visual might help somebody out there: https://appsource.microsoft.com/en-us/product/power-bi-visuals/insiderscoop1611244107840.powerbi_customviz_mass-filter?tab=overview Using this visual, you can paste a list and also sync across the report.
