Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Massive Filtering

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!

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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.

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        v-lid-msft
        Community Support
        6 years ago

        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.