Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi guys, in a slicer, after input BMW, I want the data been filted contains BMW and all the items in the slicer to be selected, how can I do that? Thank you.
Solved! Go to Solution.
Hi @Anonymous ,
When you search "BMW" in Slicer, "Select All" function will disappear.
I think Power BI doesn't support us to select all values in search slicer directly. Here I suggest you to try Text Filter which is a custom visual to replace search slicer in Slicer visual.
Result is as below. When I enter "BMW" in Text Filter and "Enter", it will filter visuals with "BMW" directly.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @Anonymous ,
I am not sure that the exact functionality you are looking for is possible but you can explore the below settings of the slicer if anything suits your requirement
There is no relative setting I can do about that. Thank you
Hi @Anonymous ,
When you search "BMW" in Slicer, "Select All" function will disappear.
I think Power BI doesn't support us to select all values in search slicer directly. Here I suggest you to try Text Filter which is a custom visual to replace search slicer in Slicer visual.
Result is as below. When I enter "BMW" in Text Filter and "Enter", it will filter visuals with "BMW" directly.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This slicer has a weakness that it doesn't tell you the item selected, is there any other slicer can both show the related tiems and make selection action at the same time?
Thank you.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
84 | |
84 | |
72 | |
49 |
User | Count |
---|---|
143 | |
131 | |
109 | |
64 | |
55 |