Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to select multiple values in the slicer

Hello,

 

How to select multiple values (ex: 100 items) in the slicer, so that i can view only data for those 100 items

ello

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks Amit for the reply.

       

      But this is not i am looking exactly. Since i have more than 1000 values to resrtict data, i cannot use " multi-select with Ctrl (By pressing)" where i need to select 1000 times to restict which is not feasible for larger values

       

      Business objects i normally work as  value1;value2; value3....... and copy these multiple values in filter search bar and easily i can restict data

       

      but i dont see any where in powerbi to use same way either, can you provide any feasible solution that will work me

       

      hope youunderstand my concern

  • westwrightj's avatar
    westwrightj
    Icon for Resolver III rankResolver III
    6 years ago

    Hey Anonymous ,

     

        Thanks for reaching out. There are a couple ways to do this.

     

         I'll detail two of them below using the following smaller sample data

     

     

    The first option would be to add a visual or page level filter to your slicer. In this case we are going to want to see the first 5 names in our slicer

     

    This is how our data looks

     

     

    After we add the following visual level filter we get a shortened response

     

     

     

    Alternatively you can go into powery query and add an index to your dataset by selecting the 'name' column and choosing index from 1

     

     

    That will give us this data

     

     

    Now what we can do is add an index slicer to filter our name slicer

     

     

    With this we can change the index number and that will adjust our name slicer like so

     

     

     

    Hope this helps - let us know if it works. If not the community can noodle up something better!