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
Hello everyone, I have a simple slicer that shows list of States and I have turned on selection controls so that the user can select all values of needed by checking “Select all” option. How do I make this select all default when my manager looks at the report?
@Seth_C_Bauer @ankitpatira @Baskar @ImkeF @Sean @Vvelarde @tringuyenminh92
Hi @PowerBIlearner,
It's not supported to set default values for the slicer recently. You can vote and comment on this idea which has the same requirement: Default Selected Slicer or Tile-By Value Configuration.
Best Regards,
Qiuyun Yu
Cool My dear friend @PowerBIlearner,
1. If nothing is select in your slicer it means all are selected . Yes it will give u the all value in slicer.
My point is nothing is different between select all and nothing seleted .
or
if u want to highlight all selected , u have select all and save the report that is the only way we have in power BI.
Right now we don't have the option default selection in power BI.
Let me know if any help
@PowerBIlearner You just need to select checkbox 'Select All' and save that report -> pin as live page -> when you share with your manager, 'Select All' would be already checked.
Hello everyone, I have a simple slicer that shows list of States and I have turned on selection controls so that the user can select all values of needed by checking “Select all” option. How do I make this select all default when my manager looks at the report?
@Seth_C_Bauer @ankitpatira @Baskar @ImkeF @Sean @Vvelarde @tringuyenminh92
Unfortuantely you cannot do that. At the same time if "select all" or everything is checked, it is treated as "select all"
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.
A user interface where both nothing selected and "Select All" mean the same thing WILL CONFUSE users.
An interface where nothing is selected doesn't mean "select all" would result in all your reports being completely blank by default. I feel like that would be more confusing to users...
Proud to be a Super User!
The user interface inconsistency should be fixed IMHO.
If the user interface is doing a "select all" then the "select all" box should be checked.
Default selections should be allowed that would help users get started and specify "select all" if that is what's wanted.
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 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
111 | |
59 | |
57 |