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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
hansolo
Helper I
Helper I

Hide Values in Slicer

 

 

 

 

 

Trying to design some "buttons" by augmenting slicers. Please see below. Is there any way I can limit values in a slicer? For instance, I just want there to be the current week, last week, etc ... not the deselect or the blank option. 

 

 

Capture.PNG

1 ACCEPTED SOLUTION
chrisu
Responsive Resident
Responsive Resident

There is a bug that disables visual-level filters for slicers.  You can workaround it by changing the slicer to another visualization (card or table or whatever), then selecting your visual-level filter (in your case, value is not blank), then changing the visualization back to a slicer.  The filter won't actually show up in the slicer's visual-level filter menu, but it will still be applied.  

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

How are you creating the values. e.g.  last 7 days, WTD, for the slicer? I'd like to do something similar with Google Analytics data. Feel free to msg me directly so this thread doesn't go off track.

 

Thanks,

Jeff

chrisu
Responsive Resident
Responsive Resident

There is a bug that disables visual-level filters for slicers.  You can workaround it by changing the slicer to another visualization (card or table or whatever), then selecting your visual-level filter (in your case, value is not blank), then changing the visualization back to a slicer.  The filter won't actually show up in the slicer's visual-level filter menu, but it will still be applied.  

This solution isn't working for me in Version: 2.38.4491.282 64-bit (August 2016)

chrisu
Responsive Resident
Responsive Resident

Yes, this workaround was disabled a few months ago.  Please vote on the following idea to bring it back:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15091614-can-no-longer-filter-a-s...

@chrisu amazing. thank you. 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

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

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