Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Filtering in PBI and Pivots in Analysis for Excel

It would be extremely useful to be able to paste multiple items in the filters rather than scroll down a long list to select 50 of those irems manually. Even search does not help since you still need to search each item individually.

 

When it somes to filtering on a specific list of accounts/customers for example, and there is no other hierarchy to help with the specific selection, it is impossible to generate that list manually having to select each of the 50 or 100 items one by one. 

 

In BW for example I was able to create a string: item1&item2&Item.....&item100. Paste this in the filter/search field and voila, all would be correctly filtered. 

 

There is no such capability in PBI and Pivots? It is high time we had it. 

 

Thak you

Alla Sion

Status: New