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...
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.

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.