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.
Hi,
I was wondering if it is possible use a slicer to select all records with a partial word. For example please see attached screenshots.
I have a list of names and rows worth of data. I would like to filter on that list and start typing "cat" and then select all results with "cat" in the name.
Is this an option for a slicer?
Thanks!
Solved! Go to Solution.
Hi @NBOnecall ,
If you click on top of the slicer on the 3 dots you can active the search option for the slicer then you can write what you want on the slicer:
If you leave this option active when publishing the users can use it.
Following the option given by @parry2k you have several ones like:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380859?tab=Overview
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?tab=Overview
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @NBOnecall ,
If you click on top of the slicer on the 3 dots you can active the search option for the slicer then you can write what you want on the slicer:
If you leave this option active when publishing the users can use it.
Following the option given by @parry2k you have several ones like:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380859?tab=Overview
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?tab=Overview
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@MFelix The second option you linked, Text Filter, is the best solution to this I believe. Though you can't deselect ones you don't want it will allow me to get most of the ones I want in my case. The other downside though is that it doesn't sync between pages in the pbix file, oh well.
Thanks!
But on the search and drop down, there isn't a select all function. I would have to go through and indivdually click each one. This isn't the solution I was hoping for.
For me this is working by clicking on the slicer, than on format, than on selection controls.
even in a dropdown slicer
@HDD009 but select all option will disappread if you do a search in slicer
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Okay that is true, now I see the issue.
We are back to what I originally posted. 🙂
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I agree that you can select all in that format, but if you hit the ellipsis and choose search you can then type a part of the word, but you can't select all based of that selection.
@NBOnecall that's what I originally replied that unfortunately it is not available.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@NBOnecall i don;t think it is availabe presently, may be check on ideas forum if there is idea for this already and vote it, if not then create new idea.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |