Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Lalitha
Frequent Visitor

How to force slicer to select first value by default

How to force slicer to select first value by default?

7 REPLIES 7
natabird3
Skilled Sharer
Skilled Sharer

chiclet slicer has the ability to force select, however i have discovered that it is limited to 2 slicers per page, more than that breaks the slcier and doesnt work as intended. Anyone found another way to force selection?

MattAllington
Community Champion
Community Champion

You can’t. But you could select the first value, add a bookmark with this item set, then add a button connected to this bookmark. Call the button reset. When the user clicks the button, the first item will be selected


* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Thanks for your reply. But this may not help in our requirement as user don’t select anything in the slicer that is the reason am thinking to select the first value by default.But it is sure that there is only one value in the slicer but I want it to select the only value by default.

What ever settings are applied to slicers when you publish to PowerBI.com will be the default. So set what you want, then publish. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

I tried to keep a slicer inside bookmark button but the problem is It is taking only one action( instead of performing both selection in slicer and selection on button it is performing only slicer selection action) it is not performaing button ( bookmark action)

Hi @Lalitha ,

 

I'm afraid that we cannot set default slicer in Power BI currently.

 

You could vote the similar idea which has been submitted in Power BI ideas forum.

 

Here are two workarounds which may help you.

 

https://www.youtube.com/watch?v=pCgK-Ze3nhA

 

https://www.techmikael.com/2017/12/a-workaround-to-setting-default-slicer.html

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Here That single value is dynamic because that is the value coming from drill through from home page.so what ever the value we select in the home page that for drillthrough that is displaying in this page slicer.
I thought to capture or select that value so that it will reflect on other bookmarks.
Here I have homepage which is not having slicer and we need to pass drillthrough to the page1.
But page1 is having 3 tabs which are bookmarks for page2 and page3.
So our requirement is what ever value we are passing from homepage drill through that value should be captured and pass as value to remaining bookmarks.
Here for sync slicer purpose I created bridge table for common value in all pages.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors