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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
ThomasDay
Impactful Individual
Impactful Individual

reset slicer without bookmark

Hello Fellow Daxers

 

Is it possible to reset a slicer using a Dax measure and not a bookmark?  I have a matrix, filtered by providers.  If just two providers are set--I have a slicer that presents some nice options to look at various pieces of a venn diagram.  (ALL, BOTH, 1 only, 2 only).  But if a user selects three or 50 providers, the slicer should basically just show ALL and no other options.  

 

What happens, is if the last slicer selection is BOTH...and the user picks more providers--I can get the slicer to show one item, but can't get the slicer to reset so that it will always show ALL (or disappear for that matter.) 

Here's the measure I use to filter to get it to show just one item if more than 2 providers:  I was hoping the filter in the Calculate would reset the table and therefore the slicer.  I know, that doesn't make sense...but what does?

NotHeadToHeadFilter = IF([DestProvCountForMatrix] <> 2, CALCULATE([DestProvCountForMatrix],JoinOptions[Index] = 1),2)


I can do this with buttons/bookmarks, but I'm curious so...is there another way?  Here's a sample .pbix and some screenshots.  Thank you! Tom

This one is Great!This one is Great!Want to have it reset to ALLWant to have it reset to ALL

 

5 REPLIES 5
amitchandak
Super User
Super User

@ThomasDay , I doubt on desktop. You have an option in power bi service. So if the report will be viewed on service their option to reset.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak  Yes, the report will be viewed in power bi service.  That's encouraging...how do I reset the slicer in service?  Thank you, Tom

Anonymous
Not applicable

Hi @ThomasDay,

If you are work on the 'read view' mode of power bi reports, it is possible to use 'rest to default' option to restore all the changes to raw report contents. (it does not clear up all filter effects and it just the restore to raw graph)

Announcing Persistent Filters in the Power BI Service 
Regards,

Xiaoxin Sheng

ThomasDay
Impactful Individual
Impactful Individual

@Anonymous Thank you for your suggestion...that's not really what I'm after but thank you for thinking of ways I might be able to get to what I'm looking for.  Tom

Anonymous
Not applicable

Hi @ThomasDay,

In fact, current power bi does not support to use of DAX formula to change slicer selections.

It is possible to use the measure as a filter and use it on visual level, but it not modify the current selections. (it can filter the visual item list based on formula expression to achieve some operations which default slicer features not support. e.g. or logic filter, reverse filter...) Applying a measure filter in Power BI 

Perhaps You can submit an idea to improve the slicers features.

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 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.