Massive Filtering

[Anonymous]

Hello,

I have data regarding 4.000 items and I need to filter around 380. Next week I will need to do a similar filtering but regarding other 400 different items. They are not sequencial, so I do not know if I have to do a basic filtering one by one. Is there any quick solution? Thanks!

[v-lid-msft]

Hi @Anonymous ,

We can put a List Slicer in your report, then use CTRL to Multi Choose the item you want. After finished the filter, We can use Bookmarks  feature to save the filter result. Or we can create a Group column to catagory your data first.

Best regards,

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

[Anonymous]

thanks @v-lid-msft ! very useful! however, do you know if  is there any option building a variable with any function that allows me to filter all the items all at once?  Something like:

Filter (item1, item80, item55, item2011, etc)

Thanks!

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

In Power BI Desktop, We can use a calculated table and relation as a workaround, create a calculated table as following:

FilterTable = {"Item 1", "Item 2"}

 Then we put the Value Field in FilterTable in all page Filter, when not select, it will not filter anything, but if you put filter as following (Select All and unselect the Blank), you can get filter the item in the formula.

It can also save as a bookmarket.

BTW, pbix as attached.

Best regards,

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