Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
How to select multiple values (ex: 100 items) in the slicer, so that i can view only data for those 100 items
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!
@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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |