How to select multiple values in the slicer

[Anonymous]

Hello,

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

[westwrightj]

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!

[amitchandak]

@Anonymous , By Default with Ctrl (By pressing). Or go and change option multi-select with Ctrl. Then just by click

https://www.youtube.com/watch?v=NI8Y3dgRRvg

[Anonymous]

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

[v-lili6-msft]

HI @Anonymous 

iF you disable "Multi-select with CTRL" for the slicer

or if you could try to use custom visual: Text Filter

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Reviews#

Regards,

Lin